WorksheetBase::Controls Property

 

Gets the collection of managed controls that are contained on the worksheet.

Namespace:   Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

C#
C++
F#
VB
Copy 
public:
property ControlCollection^ Controls {
	ControlCollection^ get();
}

Property Value

Type: Microsoft.Office.Tools.Excel::ControlCollection^

A ControlCollection that contains all the managed controls on the worksheet.

A worksheet in an Office solution can contain Windows Forms controls and host controls. For more information, see Controls on Office Documents.

To manage the controls on a worksheet at run time, use the methods and properties of the ControlCollection object returned by the Controls property. For more information, see Adding Controls to Office Documents at Run Time

The following code example uses the Controls property to add a Button to the current worksheet.

This example is for a document-level customization.

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.
Return to top
Show: