Article ID: 104840
Article Last Modified on 9/20/2005
APPLIES TO
- 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
SUMMARY
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.
MORE INFORMATION
In earlier versions of Microsoft Excel, to create accelerator keys in custom dialog boxes, you use the ampersand character (&).
REFERENCES
"Visual Basic User's Guide," Chapter 11
Additional query words: XL
Keywords: KB104840