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



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