Thread: VBA shortcut
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Edwin Tam (MS MVP) Edwin Tam (MS MVP) is offline
external usenet poster
 
Posts: 48
Default VBA shortcut

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