Create a VBA macro in sheet

Create a VBA macro in sheet

To create a macro:

  1. Click Tools > VBA Macros > Create. 
  2. The Create Macros menu is displayed.
  3. Name the macro that you wish to create. You can also describe the functioning of the macro. Note that the macro name can only consist of alphabets, numbers and underscore .
  4. You can choose to either record the macro or write the code for macro using VBA editor.