Thanks Chip, it works perfectly.

-----Original Message-----
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


.