Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/104840

From BetaArchive Wiki
Knowledge Base

Assigning an Access Key to a Custom Dialog Box Control

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:

  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

Additional query words: XL

Keywords: KB104840