Short cut keys within excels VBA Forms

G

Guest

On previous versions if you put E&xit within the Caption property of a
command button, when you ran the code you could press Alt + X as a shortcut
to close the form. Does anyone know how to do this in Excel 2007 as this way
doesnt work.

Thanks
 
C

Chip Pearson

I don't think that is the way it has ever worked. Perhaps you are thinking
of VB6, which does work this way. In Excel/VBA, you've always had to use the
Accelerator property to assign a keystroke to a control.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 

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

Menus and short cut keys 4
using Forms and VBA within Excel 3
Disable Cut/Copy/Paste in Excel 2010 0
Assigning shortcut keys in Word thru Tools->Customize 1
Templates + short-cut keys 4
Alt keys don't work 1
Short cut keys lost when new version of template is saved 4
Using Word shortcut keys in Outlook 2007 1

Top