[RESOLVED] How to assign access key to a button control vba?

Printable View

May 31st, 2006, 02:44 AM
poojathakur_13

[RESOLVED] How to assign access key to a button control vba?

hi all, i have a userform in excel vba . i want to assign access key to the controls on it. can any one help.
thanx
May 31st, 2006, 02:47 AM
RobDog888

Re: How to assign access key to a button control vba?

Which application? Access, Excel, Word?
May 31st, 2006, 03:01 AM
poojathakur_13

Re: How to assign access key to a button control vba?

Excel..
May 31st, 2006, 03:02 AM
Shuja Ali

Re: How to assign access key to a button control vba?

Quote:

Originally Posted by RobDog888

Which application? Access, Excel, Word?

Excel I guess..

Quote:

Originally Posted by poojathakur_13

hi all, i have a userform in excel vba
May 31st, 2006, 03:07 AM
RobDog888

Re: How to assign access key to a button control vba?

:lol: Its last Shuja Ali :D

Then for the userforms in Excel - set the Accelerator property to the letter that is to receive the shortcut.
May 31st, 2006, 03:40 AM
poojathakur_13

Re: How to assign access key to a button control vba?

Thanks for the help.

All times are GMT -5. The time now is 08:57 AM.