- Choose File → Options → Customize Ribbon. The Customize the Ribbon dialog appears.
- In the Customize the ribbon section on the right side of the dialog, click the Developer checkbox.
- Click OK. The Developer tab is now on the ribbon.
- Create a new workbook.
-
Select a cell. Any cell will do.
-
Choose Developer → Code → Record Macro or click the macro recording button on the status bar.
The Record Macro dialog box appears.
The Record Macro dialog box appears when you’re about to record a macro. -
Enter a name for the macro.
Excel provides a default name (something like Macro1), but it’s better to use a more descriptive name. NameAndTime (with no spaces) is a good name for this macro.
-
Click the Shortcut Key box, and enter Shift+N (for an uppercase N) as the shortcut key.
Specifying a shortcut key is optional. If you do specify one, you can execute the macro by pressing a key combination — in this case, Ctrl+Shift+N.
-
Make sure the Store Macro In setting is This Workbook.
-
You can enter some text in the Description box, if you like.
This step is optional. Some people like to describe what the macro does (or is supposed to do).
-
Click OK.
The Record Macro dialog box closes, and Excel’s macro recorder is turned on. From this point, Excel monitors everything you do and converts it to VBA code.
-
Type your name in the active cell.
-
Move the cell pointer to the cell below and enter this formula:
=NOW()
The formula displays the current date and time.
-
Select the formula cell, and press Ctrl+C to copy that cell to the Clipboard.
-
Choose Home → Clipboard → Paste → Values (V).
This command converts the formula to its value.
-
With the date cell selected, press Shift+up arrow to select that cell and the one above it (which contains your name).
-
Use the controls in the Home → Font group to change the formatting to Bold and make the font size 16 point.
-
Choose Developer → Code → Stop Recording.
The macro recorder is turned off.