Type your name and hit enter
Macro Name: It is important that you assign a name to your macro because Excel will give it a default name otherwise. The macro name should describe what it is going to perform.
Shortcut Key: Each macro must have an event that will take place for it to run. This event can include a press of a button or the opening of a Workbook. Once you assign the shortcut key to the macro and you press the key combinations, Excel Macro will start. Note, though, that this field is optional.
Store Macro In: A macro that is stored here means that it has an active Excel file. Therefore, if you open a specific Workbook, you can run the macro.
Description: This field is optional, but it can still be very useful when you have multiple macros in the spreadsheet. In addition, this field allows you to describe the macro to the user in greater detail.
Once the Record Macro dialog box shows up, the steps below will help you create a macro you can use to enter your name into a Worksheet.
First, specify the name of your macro. Don’t go with the default name.
Next, allocate a unique shortcut key, such as Ctrl+Shift+N, to the macro.
Select OK and exit the dialog box before you start recording.
Click any cell in the Worksheet. Type your name and hit enter.
Finally, select Developer—>Code—>Stop Recording.
