“Hello World!” with Excel VBA
This post provides a simple "Hello World" tutorial for Excel VBA beginners, covering Developer toolbar activation, writing basic code, testing…
VBA to list files in directory
Listing files in a directory is a common programming task. This tutorial walks you through how this can be achieved…
VBA to check if a file name exists
his tutorial will cover creating code to check if a specific file name exists. If you enter just a file…
Writing data to a file with VBA
In the More Windows batch files tutorial we learnt to pipe output to a text file using a batch file.…
Declaring and using Constants in VBA
This tutorial follows on from the Create a custom function in Excel tutorial and refactors the code from that tutorial.…
Create a custom function in Excel
Excel has hundreds of powerful functions. Here is how you can create your own! In this tutorial: Required knowledge: 1.…
VBA’s Environ function
This tutorial covers how to get system information using VBA. The information available ties into the Windows Environment variables and…
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.…