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.

REFERENCES

For more information about the Forms Toolbar, choose the Search button in Help and type: 

   controls

KBCategory: kbusage
KBSubcategory:

Additional reference words: 5.00 5.00a 5.00c 7.00 7.00a
Keywords : kbusage
Version : 5.00 5.00c 7.00 7.00a | 5.00 5.0
Platform : MACINTOSH WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 27, 1997
©1997 Microsoft Corporation. All rights reserved. Legal Notices.