Short cut keys within excels VBA Forms

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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)
 
Back
Top