Microsoft KB Archive/104840

= Assigning an Access Key to a Custom Dialog Box Control =

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:


 * 1) In a dialog sheet, select the desired control.
 * 2) From the Format menu, choose Object.
 * 3) Select the Control tab.
 * 4) In the Accelerator Key box, type a single letter or number.
 * 5) Choose OK to accept the change.

When you run the dialog box, you can activate that control by pressing ALT+ (where  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 (&).

