VBA (Visual Basic For Applications) is a programming language that allows you to take full control of Excel (and other Office applications).
You can use it to automate tasks and create small applications to run in Excel.
If you don’t know how to use VBA, or don’t have time to learn it, then you should look at Excel macros.
A macro (short for macroinstruction) is a small program that automatically runs Excel through a pre-recorded set of steps that you have shown it.
Then each time that you run that macro, Excel will mechanically follow the steps that you’ve shown it.
They can be very useful and allow you to completely automate standard, repetitive tasks. Once you know how recording a macro can be done very quickly.
We offer three courses that cover Excel macros & Excel VBA.
- For a quick introduction to macros, creating and editing macros is covered as the final section of our advanced Excel course. We cover the basics of recording macros and editing macros.
- For a detailed look at Excel macros, we offer a one day Excel course focused on Excel macros. By the end of this you will be a master of recording and creating macros and routines.
- For a detailed look at macros and how to edit them, the best course would be our VBA course. This will allow you to both create them and also show you VBA which can be used to edit them.