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

R

Rich

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
 
J

Jim Rech

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link a text box based on drop down box with four options MS Word 365 0
In a Control: Type some text, then hit a hotkey to append more text (?) 3
Trimming leading character from string and replace underscore withdashes 4
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Custom Hotkey Strategy 2
how to add _underscore to VB button on worksheet? 2
Macro will not be assigned to a toolbar button. 0
How to call Excel add-in macro from a button… 1

Top