Hello World! Excel VBA
I find Visual Basic for Applications (“VBA”) most useful in Excel. I have created many small enhancements to make my larger spreadsheets easier to use. Here follows a simple “Hello…
VBA for Excel: a little logic
This post follows on from the Hello World Excel VBA post which is an introduction to the world of VBA. I urge you to quickly read that post before continuing…
Clearing ALL checkboxes in an Excel workbook
Yet another “helper” script for marking CAT PAT‘s! I was modifying one of the Excel marking rubrics and to test that I had linked up all the calculations correctly with…
Display the full pathname of a Word document in the Title Bar
I have to have multiple Microsoft Word documents open when I am marking CAT practical assessment papers. As I have the Learner’s file, the original file, as well as the…