 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / November 2007Short cut keys within excels VBA Forms
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.  SignatureCordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) > 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 [quoted text clipped - 4 lines] > > Thanks |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.