Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible to hotkey/underscore a VB button on a worksheet?
Hello,
Is it possible to hotkey a visual basic button on a worksheet? Like in MS Access you place an ampersand (&) before the character to hotkey &Run Report would underscore the R in Run. So when you press Alt-R that would activate the button that says "Run Report". Is this doable on a button in a worksheet? How to do this? Thanks, Rich |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Possible to hotkey/underscore a VB button on a worksheet?
You cannot create a hotkey to a button but you can create a hotkey to a
macro. Check out the OnKey method in VB help. -- Jim "Rich" wrote in message ... | Hello, | | Is it possible to hotkey a visual basic button on a worksheet? Like in MS | Access you place an ampersand (&) before the character to hotkey | | &Run Report | | would underscore the R in Run. So when you press Alt-R that would activate | the button that says "Run Report". Is this doable on a button in a | worksheet? How to do this? | | Thanks, | Rich |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
underscore in functions | Excel Worksheet Functions | |||
underscore in email address covered by hyperlink underscore | Excel Discussion (Misc queries) | |||
How can I double underscore in excel? | Excel Worksheet Functions | |||
how can i make a measurment with and underscore under the second | Excel Discussion (Misc queries) | |||
Underscore character _ | Excel Programming |