Creating a Macro using the Recorder

We will create a simple command macro that will insert your name in any selected cell.

Exercise

Open a new worksheet, or clear the old one if you have one displayed.

Select cell A1. This could have been any cell but we will use A1.

Open the TOOLS Menu and select MACRO then RECORD MACRO.

The following menu is displayed.

Click Record New Macro

Now complete the Dialog box that is displayed.

In this box you will assign a name and an optional key-stroke to the macro that you are about to create.

Type in MyName, with no spaces and click OK.

Your actions are now being recorded as you perform them

Type in your first name, ie James, and press enter.

Click the Stop Recording Button that appears on your worksheet.

Your macro is now recorded for you onto a module sheet.

Now remove your name from cell A1.

From the Tools menu select Macro Macros

Select the Myname macro and press Run

Your name should appear.

Well Done !, You have just Recorded and Run your first Macro.

---