How To Use The VBA Code You Find Online

How To Use The VBA Code You Find Online

by | Dec 14, 2016 | VBA

So you needed to do something in Excel and after a bit of searching online, the solution you found involves some VBA code (visual basic for applications). If you’ve never used VBA and don’t know where to put the code and how to run it then follow this step...
How To Create A Data Entry Form Without VBA

How To Create A Data Entry Form Without VBA

by | Dec 13, 2016 | Tips

Data entry isn’t fun, but sometimes it has to be done. Excel has a neat hidden feature made just for data entry. The data entry form allows you to view one record at a time in a more natural horizontal orientation which can make the data entry a bit easier in...
How To Add A Macro To The Quick Access Toolbar

How To Add A Macro To The Quick Access Toolbar

by | Dec 12, 2016 | Tips

Do you have a favourite? Maybe you want to be able to run it easily without going to the Developer tab > Macros button > select it from the Macros window and hitting the Run button? There is a quicker way (without assigning a keyboard shortcut), you can have it...
How To Get All Comments In A Workbook With VBA

How To Get All Comments In A Workbook With VBA

by | Dec 11, 2016 | VBA

Comments can be a great way to add a small bit of documentation to your spreadsheets. If your spreadsheet gets too big and with many sheets then important comments can easily get lost somewhere in the workbook and forgotten about. Here we’ll show you an easy way...