hotkey for command button on Excel form
 

I have an Excel form that I am using for data entry. On the form, I have
several command buttons that I want to assign hotkeys to, but the standard of
setting the caption with an ampersand before the character does not seem to
work. The caption displays the ampersand rather than underlining the
character following the ampersand.

What am I doing wrong?

--
Email address is not valid.
Please reply to newsgroup only.

hotkey for command button on Excel form
 

Hi

You could use the Acclerator property of the buttons.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Dale Fye" wrote:

I have an Excel form that I am using for data entry. On the form, I have
several command buttons that I want to assign hotkeys to, but the standard of
setting the caption with an ampersand before the character does not seem to
work. The caption displays the ampersand rather than underlining the
character following the ampersand.

What am I doing wrong?

--
Email address is not valid.
Please reply to newsgroup only.

hotkey for command button on Excel form
 

Thanks. Worked just like I wanted it to, although I have a Find button and
it didn't like the "F". Any particular reason for that?

--
Email address is not valid.
Please reply to newsgroup only.


"Wigi" wrote:

Hi

You could use the Acclerator property of the buttons.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Dale Fye" wrote:

I have an Excel form that I am using for data entry. On the form, I have
several command buttons that I want to assign hotkeys to, but the standard of
setting the caption with an ampersand before the character does not seem to
work. The caption displays the ampersand rather than underlining the
character following the ampersand.

What am I doing wrong?

--
Email address is not valid.
Please reply to newsgroup only.

hotkey for command button on Excel form
 

You probably have already another control with F as the accelerator key.
Note that the accelerator is case sensitive. You can use F for one control
and f for another. James

"Dale Fye" wrote in message
...
Thanks. Worked just like I wanted it to, although I have a Find button
and
it didn't like the "F". Any particular reason for that?

--
Email address is not valid.
Please reply to newsgroup only.


"Wigi" wrote:

Hi

You could use the Acclerator property of the buttons.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Dale Fye" wrote:

I have an Excel form that I am using for data entry. On the form, I
have
several command buttons that I want to assign hotkeys to, but the
standard of
setting the caption with an ampersand before the character does not
seem to
work. The caption displays the ampersand rather than underlining the
character following the ampersand.

What am I doing wrong?

--
Email address is not valid.
Please reply to newsgroup only.