View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson[_2_] Chip Pearson[_2_] is offline
external usenet poster
 
Posts: 95
Default How to cause userform to display

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