If you want to know the location of each macro in each module, press the F8 key to open the Macro History (Windows) or Macro List (Mac) window, click on a macro name and click on the macro name on the right side, and then choose the item in the List on the right side. Create a VBA Macro from Excel Sheet and Paste into Text Module. This method will use Microsoft Word function to export your Excel sheet as a macro. Create a sheet, right-click, and select the option Edit > Insert > VBA Macros. Select the sheet name from the left side, the header from the right side, select the option Macro Name from the drop-down menu, and choose a macro name from the drop-down menu that appears. This is how you can set the macro name by simply pressing Alt-F8. Now, you can press F9 or Alt-F9 to generate a VBA macro. If you want to edit the macro, copy & paste it to a different text document in Excel. Convert/Open Microsoft Excel for VBA Macro This method is used to open and save VBA macros into Excel file. After you have set up VBA macro or opened a VBA macro file, you can open the Macro window from the Tools panel and then type (Paste) a macro code using VBA. Create a Macro from Visual Basic Module (Macro) (Windows) The same method is used to create a VBA macro from a Visual Basic module. The same way I have shown above, you can open a VBA macro from the Tools panel and then type the VBA code into the VBA window. Microsoft Excel macro file converter To convert Word and Excel macros to Visual Basic for Excel, you can use the Microsoft Excel macro file converter software. The software will generate the necessary Excel macro for you, but the result will be converted to Excel file and will be saved on your PC.