Assigning an Access Key to a Custom Dialog Box Control

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+<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