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

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

how to add _underscore to VB button on worksheet? 2
Custom Hotkey Strategy 2
Trimming leading character from string and replace underscore withdashes 4
In a Control: Type some text, then hit a hotkey to append more text (?) 3
Hotkey that finds a character, then positions cursor on it? 6
how to make newline in VB button caption on workshett? 2
Control hotkey on inherited form 3
Run Macro in one worksheet from a button on another worksheet 2

Top