Visual Basic for Applications
Visual Basic for Applications (“VBA”) is an implementation of Microsoft’s event-driven programming language Visual Basic 6.0 built into most desktop…
Excel VBA to select a cell based on its value
I use a workbook to keep a digital register for each of my classes. There is a column per day,…
VBA looping through Text Boxes in Word
The tutorial explains how to find and replace text in textboxes via Excel VBA, providing code to loop through textboxes…
Checking for blank cells in Excel with VBA
An easy-to-follow tutorial describing how to write VBA in Excel to find blank cells.
Loop through all open Word docs with VBA
This VBA code snippet loops through all open Word documents, displaying the Document names one by one in a popup.…
VBA to duplicate worksheets in Excel
This is part of a larger Excel VBA project I am working on. I want to duplicate worksheets based on…
Excel VBA Copy Each Sheet to a Workbook
I use digital mark sheets to mark ICT Practical Assessments; each student is marked on an individual worksheet in a…
Password-protecting your VBA Project
This post is a follow-up on how to protect Excel worksheets, providing guidance on securing a VBA Project. It details…
VBA to protect & unprotect Excel worksheets
This is part of a larger Excel VBA project that I am working on. The sheet is protected, but I…
VBA to manipulate Track Changes settings in Word
This tutorial explains how to use VBA for looping through all open Word documents and enabling Track Changes in each…