ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Userform button - shortcut key? (https://www.excelbanter.com/excel-programming/361490-userform-button-shortcut-key.html)

MattShoreson[_107_]

Userform button - shortcut key?
 

Usually when creating a menu item or the such like an ampersand denotes
which letter you want as a shortcut key.

How can I emulate the same behaviour on a button on a userform?

Cheers in advance,
Matt.


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=542108


Peter T

Userform button - shortcut key?
 
Hi Matt,

Put your shortcut letter in the Accelerator property of the control. If the
letter is in the controls caption it will be underlined.

Regards,
Peter T

"MattShoreson"
wrote in message
...

Usually when creating a menu item or the such like an ampersand denotes
which letter you want as a shortcut key.

How can I emulate the same behaviour on a button on a userform?

Cheers in advance,
Matt.


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile:

http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=542108




MattShoreson[_108_]

Userform button - shortcut key?
 

thanks Peter T


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=542108



All times are GMT +1. The time now is 08:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com