Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA shortcut
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
shortcut has change or move so this shortcut can not open | Excel Worksheet Functions | |||
Is there a shortcut for this?? | Excel Discussion (Misc queries) | |||
MAC shortcut key | Excel Discussion (Misc queries) | |||
Is there a shortcut? | Excel Discussion (Misc queries) | |||
Shortcut Key | Excel Discussion (Misc queries) |