Share via


How to: Locate NamedRange Controls on a Worksheet

Applies to

The information in this topic applies only to the specified Visual Studio Tools for Office projects and versions of Microsoft Office.

Project type

  • Document-level projects

Microsoft Office version

  • Excel 2007

  • Excel 2003

For more information, see Features Available by Application and Project Type.

When you add a NamedRange control to a worksheet, there is no visual representation of the control. You can use the Properties window in Visual Studio to locate the control, or you can use the Name Box in Excel.

To Locate a NamedRange control using the Name Box

  1. Click the drop down arrow to the right of the Name Box in Excel.

    The Name Box is located to the left of the formula bar, just above column A of the worksheet.

  2. Select the NamedRange control that you want to locate.

    The NamedRange control is selected in the document.

To Locate a NamedRange control using the Properties Window

  1. Select the worksheet that contains the host control in Solution Explorer.

  2. Click the drop down box at the top of the Properties Window.

    A list of all objects available in the worksheet appear in the drop down box.

  3. Select the NamedRange control that you want to locate.

  4. The NamedRange control is selected in the document.

See Also

Tasks

How to: Add NamedRange Controls to Worksheets

How to: Delete NamedRange Controls at Design Time

How to: Resize NamedRange Controls

Other Resources

Excel Host Controls