View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
losmac[_2_] losmac[_2_] is offline
external usenet poster
 
Posts: 44
Default How to cause userform to display

Insert new module.
Write procedure which shows userform.

Sub ShowMyForm
MyForm.Show
End Sub

Tools - Macro - Macros
Select macro ShowMyForm
Click button Options..
Put there keyboard shortcut...

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