Possible to hotkey/underscore a VB button on a worksheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
| 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
 
Back
Top