VBA snippet to open userform1 by keyboard shortcut

[Karthik Thandapani]

Hi,

Can anyone help me with a VBA code snippet to open up a userform using keyboard shortcut. My requirement is to enter values from the userform that has a select key within.

Please see the attached file.

Thanks in advance!

 

[Lymm]

sub showuserform1()
Userform1.show
End sub

Paste into a module. and asign a shortcut key to it. ? Is this the sort of thing you were after?

 

[Karthik Thandapani]

@Lymm , that's true. Now where can I assign a shortcut key to the userform?

 

[Lymm]

Sorry i run excel 2003 so your procedure may be different. But alt F8 or Tools,macros or something similar will bring up a list of macros. Choose the one in "This workbook" then options, then a window opens with the option of asigning a shortcut key to the macro. Hope that helps a bit.

 

[vijay.vizzu]

In 2007 or above, Press Developer Tab (If not appears, go to file->options->customise ribbon-> right hand side pane, tick Developer tab) and press Macros Tab->a Macro Popup window will come->select your macro name -> click options -> then you can assign short cut key..

I hope this information will help you