Read this easy and quick article on what is Excel Macros, how to use macros and where it can be used.
What is VBA?
- VBA is Visual Basic for Applications
- VBA is Editor in Excel, Word and PowerPoint
- VBA is a part of the application, it cannot run independently as VB
- VBA is used in Desktop-based applications and VBS is a script language used in the web applications.
What is Macros?
- Macros is object oriented program
- Macros is part of coding that is written in VBA
- Macros is a programming language
Why Macros?
- For repeated task
- To record the change
- To create new formulae
- To simplify complicated task
The Object Model
VBA is object-oriented, before you perform any actions you need to specify what object to perform on. VBA syntax is object-first then action. Objects can have relationships with other objects. This relationship is called the object hierarchy. Macros are also called a subroutine, procedure, program.
Ways to run Macros (VBA Code)
- Use shortcut key Alt + F8 get to view macro and then select your macro and run
- Go to Tab Developers / Macros
- Go to Tab View/Macros
- Use the shortcut key you assigned
- Insert any shape or image and assign the macro to it (Right mouse click and Assign Macro)
- Insert a Form Control Button from Developer Tab, Insert, Form Controls
How to Record a Macros
We can start Recording a Macro in the 4 ways mentioned below:
- Click on the record macro button at the bottom left hand side
- Use Shortcut Alt + T + M + R
- Go to Developer tab – Record Macro
- Go to View Tab – Record Macro
Now name your macros, assign a shortcut key and decide where to store them (workbook or personal macro workbook)
Run through the steps the macros needs to do
Stop the Macros.
You can also read the article about Excel Shortcut. You can also enrol in our Advance Excel Course.