ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   shortcut keys (https://www.excelbanter.com/excel-programming/347471-shortcut-keys.html)

Ben

shortcut keys
 
Hi all,

Is there a way so that when creating a command button, I can assign a short
cut key using the (&) as I can do in VB? Thanks.

Ben
--


Leith Ross[_352_]

shortcut keys
 

Hello Ben,

Select a letter the letter you want to use as the the hot key and put
in the "*Accelerator*" property for the CommandButton. The letter must
be one that appears in the *Caption*.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=491176



All times are GMT +1. The time now is 02:26 PM.

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