Excel creates a form command button animation tutorial with macros

Excel2003 Tutorial 57, create a Form command button with macros.

Demo Animation

Operation Steps

It's not easy to call macros by running the Macros dialog box, call macros through shortcut keys, and if you can't remember a lot of macros, let's add a button to the Excel table.

If the macro is valid only for the current workbook document, I recommend that you add a form command button to the workbook document to invoke the macro:

To do the View toolbar Form command, expand the Forms toolbar.

Click the command button button on the toolbar, and then drag a button out of the worksheet.

The system automatically pops up the Specify Macros dialog box, selects the macro you want to call, and determines the return.

Change the character on the command button to an appropriate content, adjust the command button size, and position it in the appropriate position on the worksheet.

Click the button to perform the corresponding macro.