Click the floppy disk icon on the VBA editor toolbar to save the code. Close the VBA editor window. Right-click the new command button and highlight the default "Button 1" text.

VBA is a powerful program that enables non-programmers to create and edit macros. Learn how to enable & use VBA in Microsoft Excel.

When the button must appear in a dialog box, create it using Excel's Visual Basic for Applications window. Once you have made the button, you can then code the VBA event that you want it to run.

After creating UserForm1 for one Excel application, you realize that you'll want to use it again -- with a few modifications -- in another application. You do not need to recreate the form; simply ...