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
Microsoft Office version
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
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.
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
Select the worksheet that contains the host control in Solution Explorer.
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.
Select the NamedRange control that you want to locate.
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