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

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 ...

You can assign a keyboard shortcut to Excel macros written in VBA code, just as you can with recorded macros. Since you're using macros to save time, triggering them with keystrokes is a great idea.

Open your worksheet in Excel. ALT-F11 (opens the VBA coding window) Copy/Paste the above code into the editor ALT-F11 (switches back to Excel) Save-As a Macro-Enabled Workbook ...