Getting Started Using the Recorder to Create a Sub Procedure

Getting Started Using the Recorder TO Create a Sub Procedure 

The Recorder creates Visual Basic commands. You don t have to know anything about Visual Basic to record a command macro in Visual Basic. This provides a good way to gain some initial familiarity with Visual Basic. 

The Record Macro dialog box displays the default name that Excel has assigned to this macro Macrol, Macro2, etc. Change the name in the Macro Name box to ScientificFormat (no spaces are allowed in a name). The Store 

Now choose Cells... from the Format menu, choose the Number tab and choose Scientific number format, then press OK. Finally, press the Macro Stop button. 

This macro consists of a single line of code. You ll learn about Visual Basic code in the chapters that follow. 

---