Button Shortcut / Key Stroke
 

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?

Button Shortcut / Key Stroke
 

NeverMind I got it Thanks

"Dan" wrote:

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?

Button Shortcut / Key Stroke
 

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).

"Dan" wrote:

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?

Button Shortcut / Key Stroke
 

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

Button Shortcut / Key Stroke
 

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

--
HTH

Bob Phillips

"Dan" wrote in message
...
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?