Microsoft KB Archive/115134

= Microsoft Knowledge Base =

XL: Controls Numbered Sequentially on Worksheet and Dialog
Last reviewed: March 27, 1997

Article ID: Q115134

5.00 5.00c 7.00 7.00a | 5.00 5.00a WINDOWS | MACINTOSH kbusage

The information in this article applies to:


 * Microsoft Excel for Windows 95, versions 7.0, 7.0a
 * Microsoft Excel for Windows, versions 5.0, 5.0c
 * Microsoft Excel for the Macintosh, versions 5.0, 5.0a

SUMMARY
In Microsoft Excel, when you insert a control on a worksheet or dialog sheet using the Forms toolbar, each control that you insert on that sheet is numbered sequentially, for example List Box 1, Check Box 2, Option Button 3, and so on. The sequential numbering is not maintained strictly within like items, such as List Box 1, Check Box 1, List Box 2, and so on.

This behavior is by design in Microsoft Excel. Each number for a control must be unique, because when you reference the control in a macro, you can just use the number of the control.

The sequential numbering of controls is not maintained across different sheets; the numbering starts again for controls on a new worksheet.

MORE INFORMATION
You can rename a control by doing the following:


 * 1) Select the control on the worksheet or dialog sheet.
 * 2) In the name box, type the new name for the control and press ENTER.

When you select the object, a new name appears in the name list.