hotkeys issue

[irresistible007]

In VB i have read that if the caption of a command button is set to "&OK" instead of "OK" it sets O as a hot key and Caption of that button would change into "OK" instead of "OK"...

But when i am doing it in VBA (excel) it isnt working...why?

 

[Norie]

What type of button is it?

 

[irresistible007]

simple command button on a User form... i had even tried it (command control) on a worksheet

 

[Norie]

How is it not working?

Try setting the Accelerator property.

I only think it's in Access, and perhaps other apps, that you can set the hotkey by just putting a & in the caption.