Inside Microsoft Excel


Assign a shortcut key to your UserForm

Inside Microsoft Excel

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.

To assign a shortcut key:

  1. Press to switch to the workbook screen.
  2. Choose Tools[…]
 

Subscribe to Inside Microsoft Excel

(get full access to archives and more)