VBA shortcut

  • Thread starter Thread starter dj
  • Start date Start date
D

dj

I used to know a way to create shortcuts for the command
buttons on a form. It would underline the 1st letter and
that would be the shortcut... I'm pretty sure it had
something to do with the naming convention. Can someone
refresh my memory? (I hear memory is the first to go and
I'm almost bald so it must have already went)

Thanks in advance~
dj
 
On your userform, select the commandbutton
In the Properties Window (the window which list a lot of properties of that commandbutton you just selected), look for the item "Acceleartor". In the box next to it, enter the shortcut key you want to assign to the button

For example, you assigned the letter "a" to it
When your userform is loaded, you can press Alt+a to use that commandbutton

Regards
Edwin Ta
(e-mail address removed)
 
Back
Top