Shortcut keys in forms (Excel)

[ribsa3]

Hi

I would like to enable the use of shortcut keys in a userform - typically being alt-o for ok and escape for cancel. I cannot seem to find these properties as default, so I am wondering if I can employ the OnKey method in any way or if there are even simpler solutions.

I am using a third party button control so I cannot define buttons as ok or cancel buttons, so it would have to be that pressing alt-o or escape triggered a subroutine to perform the desired tasks.

Kindly,
Bjoern Sandvik



--------------------------------------------------------------------
Do what you wish, as long as it harms no one. That includes yourself.

 

[jajinder]

Hi Bjoern....
Sandvik had great tools..... (hahaha)

I'm not sure if it will work... but you could try this:

Private Sub WorkBook_Open()
Application.OnKey "{set here name of shortkey}, "Execute" '(whatever name)

Sub Execute()
UserForm1.Show 'or something else of course
End Sub

Hope it'll work...

Greets Jajinder

 

[ribsa3]

Yeah - pretty good tools.. Just not for VBA, obviously!

Your suggestion is not bad, nor is it optimal since declaring Application.OnKey affects the entire application. If there were a way of declaring this isolated withing a form instance, then it would be great.

Seconds?..



--------------------------------------------------------------------
Do what you wish, as long as it harms no one. That includes yourself.

 

[jajinder]

Hi Mr. Toolman Sandvic...

Seems I was wearing the wrong goggles...
You just want to use shortcuts to go to the next form, but are using 3th-party-buttons. Is replacing the buttons with regular CommandButtons an option?

Greets Jajinder