Inside Microsoft Excel

Assign a shortcut key to your UserForm

by Stephen Nebel

In our article, “Number multi-source documents easily with a comprehensive printing utility,” we set up our code to display the utility’s UserForm each time you open the workbook. When you’re done, you can close the form, but what if you want to redisplay it and print some more? Let’s set up a shortcut key alternative to quickly display the form.