Recording a macro, adding modules, browsing objects, and variables
Before you get your hands "dirty" with coding in VBA, there are a few things you need to know. These things will help when it comes to coding. In this section, you will learn how to:
Record a macro
Add modules
Browse objects
Get some background on declaring variables
We will start with macro recording, a feature which is available in most Office applications.
Recording a macro
A macro, in Office applications, is a synonym for VBA code. In Excel, we can record almost any action we perform (such as mouse clicks and typing), which in turn is registered as VBA code. This can come in handy when we need to discover properties and methods related to an object. Let us now have a look at some ways you can record a macro in Excel. There are two options:
Recording a macro from the status bar.
Recording from the Developer tab.
Option 1 – Recording a macro from the status bar
From the status bar, click on the Record Macro button. If the button is...