Use Macro Recorder in Excel (within 4 Steps)
Sometimes everyone thinks to complete some steps automatically in Excel so that time can be saved. However as a VBA beginner, it’s hectic to code the exact macro for it, but I have an easy way to do this by using Macro Recorder.
Previously: Swap Values In Excel Using Macros
Before following the procedure of this tutorial make sure you have enabled the Excel’s Developer Tab.
Macro Recorder helps to mimic each step inside the Excel even if needed in another time those steps can be reused.
First, you have to turn on the Macro Recorder then follow the given steps and then stop the Macro Recorder. To give the final touch Run the Macro and boom Excel will repeat by its own the exact same steps that you have completed now.
Following are the steps to follow:
STEP 1: first of all follow Go to Developer > Record Macro
Now continue with the default name Macro1 by clicking OK.
STEP 2: after first step it will automatically start to record so now you have to do:
- Select a Cell (as I have selected A2 cell in my example to show you)
- Then Click Bold
- And Click Italic
- After that select the Green colour from highlight colour options
In last of second step Go to Developer > Stop Recording
STEP 3: if you want to try out the macro in action then you have to select the rest of other cells on which you need to apply the actions of the macro.
Then Go to Developer > Macros
And within a click first two steps are automatically applied to other cells.
STEP 4: To check how it looks after completing
Go to Developer > Visual Basic
After that in the last step Go to Modules > Module1 to see the code that does the following in your work:
- Setting Bold
- and filling the colour with Green