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

Macro Recorder

Now continue with the default name Macro1 by clicking OK.

Macro Recorder1

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
Macro Recorder2

In last of second step Go to Developer > Stop Recording

Macro Recorder3

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

Macro Recorder4
Ensure that Macro1 is selected before clicking on Run.

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

Macro Recorder5

After that in the last step Go to Modules > Module1 to see the code that does the following in your work: 

  • Setting Bold
  • Italic
  • and filling the colour with Green
Macro Recorder6