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…
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.…
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,…
Checking for blank cells in Excel with VBA
An easy-to-follow tutorial describing how to write VBA in Excel to find blank cells.
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…
Record a Macro in Excel
Macros are handy tools for automating your work. Recording Macros and inspecting the code is also an easy and enjoyable…
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…