Microsoft KB Archive/104840
Article ID: 104840
Article Last Modified on 9/20/2005
- Microsoft Excel 95a
- Microsoft Excel 95 Standard Edition
- Microsoft Excel 5.0c
- Microsoft Excel 5.0 Standard Edition
This article was previously published under Q104840
In Microsoft Excel, to assign an access key to a control in a custom dialog box, set the Accelerator Key property. You can set this property for labels, option buttons, check boxes, command buttons, or group boxes.
To set the accelerator key for a dialog box control:
- In a dialog sheet, select the desired control.
- From the Format menu, choose Object.
- Select the Control tab.
- In the Accelerator Key box, type a single letter or number.
- Choose OK to accept the change.
When you run the dialog box, you can activate that control by pressing ALT+<n> (where <n> is the letter or digit you typed in the Accelerator Key box).
NOTE: You cannot use access keys with On Worksheet controls. Controls must be in a custom dialog box in order for access keys to function.
In earlier versions of Microsoft Excel, to create accelerator keys in custom dialog boxes, you use the ampersand character (&).
"Visual Basic User's Guide," Chapter 11
Additional query words: XL