XL: Assigning an Access Key to a Custom Dialog Box Control

ID: Q104840

The information in this article applies to:

Microsoft Excel for Windows, versions 5.0, 5.0c
Microsoft Excel for Windows 95, versions 7.0, 7.0a

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:

Keywords :
Version : 5.00 5.00c 7.00 7.00a
Platform : WINDOWS
Issue type :