The Macro Recorder Workout
- 01:55
Workout demonstrating the use of the macro recorder.
Transcript
In this workout, we are required to record a macro to enter our name into cell B 8.
From the developer tab, we can see the record macro button.
When we click on the record macro button, we are prompted to enter a name for the macro, no spaces, no special characters.
This time, let's call it enter name one.
I'm not going to assign a shortcut key, and I will store the macro in this workbook.
When we click okay, Excel will record all of the cells that we click and everything that we enter into those cells.
I'll select cell B 8 and enter my name back to the developer tab and stop recording.
Our first macro has been recorded.
Let's check that the macro executes all of the procedures that we want it to.
I'm going to clear the contents of cell B 8 and select another cell on the spreadsheet.
I go onto the developer menu and select macros.
The view macros button will show us all of the code that we have available.
We can see here right at the top, our only macro is called enter name one, and clicking run will execute that code.
We can see that that macro writes my name into cell B 8.