Button Shortcut / Key Stroke

[Guest]

I have a button and want to create a shortcut keystroke. I VB if you go
&Button you would get an Underlined B and be able to ALT B and vola. I Go to
my command button and go to the Button name and &Button and I get &Button. No
shortcut / Key stroke. How can I accomplish this feat or is it something I
need to code within Excel? If so How do I go about that?

 

[Guest]

NeverMind I got it Thanks

 

[Guest]

For command buttons made from the Controls Toolbox there is an Accelerator
property that can be set to do what you want. However, I know of no way to
do this for a Forms button (unless you trap the keystrokes and code it all
yourself).

 

[Guest]

The Accelerator property of the command button should get you the result you
seek.

 

[Bob Phillips]

You have to set it with the caption property of the button.