Select the first button from “Form Controls” on the Controls tab. Drag the selected button anywhere in the Excel sheet. The “Assign Macro” dialog box opens. The macros to assign are listed in, To record a new macro and assign it to the button, click “Save”. ". This opens the Record Macro dialog box, where you specify a name and click "OK." The button will be assigned this macro; Follow the steps below to record the VBA macro from the Visual Basic editor. 📌 STEPS: Once the module is completed, go to the top ribbon and tap the File tab. Next, select the Save option. Alternatively, you can press Ctrl, S to save the file. As a result, a window named “Save As” will appear. Click the Customize Ribbon tab, check the Developer box under Main Tabs in the Customize Ribbon list box on the right side of the dialog box, and then click OK. Even if you don't add the Developer tab to the ribbon, the Excel status bar at the bottom of the program window contains a Record Macro button. Here are the steps to create the formula property code with the macro recorder. Activate the Developer tab of the Macro Recorder and record a macro, enter your formula, or edit an existing formula. Press Enter to enter the formula. The code is created in the macro. If your formula contains ation marks or ampersand symbols, the macro first applies general number formatting on all cells by performing a selection of all either Ctrl, A or click on the cell between the en- row and column headers and select the comma style icon under the Home tab. menu. Next, apply visual formatting to the row and column headers: Bold. Center. Background fill color. Follow these steps to run a VBA macro from the Developer tab. Go to the Developer tab. Tap the Macros command in the Code section. This will open the Macro menu which lists all macros, select the Developer tab and click Record Macro or press ALT L R. The Macro Name field says Macro1, and that is a good name. 5. Enter a shortcut key if desired in the Shortcut Key field box. Here are the steps to create the formula property code with the macro recorder. Activate the Macro Recorder Developer tab gt Record a macro Enter your formula or edit an existing formula. Press Enter to enter the formula. The code is created in the macro. If your formula contains ation marks or ampersand symbols, the macro, The first step in writing a macro is to create a new one using the macro recorder. To do this, select the Developer tab in the ribbon, click the Save Macro button in the Code group and give your macro a name. You can also assign a shortcut key and choose where to store your macro: in the workbook or in the personal macro, follow the steps below to save the VBA macro from the Visual Basic editor. 📌 STEPS: Once the module is completed, go to the top ribbon and tap the File tab. Next, select the Save option. Alternatively, you can press Ctrl, S to save the file. As a result, a window named “Save As” will appear. Different ways to copy and paste cells or ranges in Excel with VBA macros. 3-part video tutorial series.