Jim,
You can use the OnKey to assign a macro to key stroke
combination, and then have that macro show the form. For
example,
Sub SetKey()
Application.OnKey "^X","MacroName"
End Sub
Sub MacroName()
UserForm1.Show
End Sub
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Jim" wrote in message
...
Hi all, I know how to make a userform display when a user
selects new from a template, but how do I cause a userform
to display when a certain sequence of keys is
pressed...Ctrl X for example?
Thanks