Share via


ControlExtensions Class

Provides extension methods you can use to add Windows Forms controls to Excel worksheets that have been customized by using the Office development tools in Visual Studio.

Inheritance Hierarchy

System.Object
  Microsoft.Office.Tools.Excel.ControlExtensions

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

Syntax

'Declaration
<ExtensionAttribute> _
Public NotInheritable Class ControlExtensions
public static class ControlExtensions

Methods

  Name Description
Public methodStatic member AddButton(ControlCollection, Range, String) Adds a new Button control to the worksheet at the range specified.
Public methodStatic member AddButton(ControlCollection, Double, Double, Double, Double, String) Adds a new Button control to the worksheet in the specified size and location.
Public methodStatic member AddCheckBox(ControlCollection, Range, String) Adds a new CheckBox control to the worksheet at the range specified.
Public methodStatic member AddCheckBox(ControlCollection, Double, Double, Double, Double, String) Adds a new CheckBox control to the worksheet in the specified size and location.
Public methodStatic member AddCheckedListBox(ControlCollection, Range, String) Adds a new CheckedListBox control to the worksheet at the range specified.
Public methodStatic member AddCheckedListBox(ControlCollection, Double, Double, Double, Double, String) Adds a new CheckedListBox control to the worksheet in the specified size and location.
Public methodStatic member AddComboBox(ControlCollection, Range, String) Adds a new ComboBox control to the worksheet at the range specified.
Public methodStatic member AddComboBox(ControlCollection, Double, Double, Double, Double, String) Adds a new ComboBox control to the worksheet in the specified size and location.
Public methodStatic member AddDataGridView(ControlCollection, Range, String) Adds a new DataGridView control to the worksheet at the range specified.
Public methodStatic member AddDataGridView(ControlCollection, Double, Double, Double, Double, String) Adds a new DataGridView control to the worksheet in the specified size and location.
Public methodStatic member AddDateTimePicker(ControlCollection, Range, String) Adds a new DateTimePicker control to the worksheet at the range specified.
Public methodStatic member AddDateTimePicker(ControlCollection, Double, Double, Double, Double, String) Adds a new DateTimePicker control to the worksheet in the specified size and location.
Public methodStatic member AddDomainUpDown(ControlCollection, Range, String) Adds a new DomainUpDown control to the worksheet at the range specified.
Public methodStatic member AddDomainUpDown(ControlCollection, Double, Double, Double, Double, String) Adds a new DomainUpDown control to the worksheet in the specified size and location.
Public methodStatic member AddHScrollBar(ControlCollection, Range, String) Adds a new HScrollBar control to the worksheet at the range specified.
Public methodStatic member AddHScrollBar(ControlCollection, Double, Double, Double, Double, String) Adds a new HScrollBar control to the worksheet in the specified size and location.
Public methodStatic member AddLabel(ControlCollection, Range, String) Adds a new Label control to the worksheet at the range specified.
Public methodStatic member AddLabel(ControlCollection, Double, Double, Double, Double, String) Adds a new Label control to the worksheet in the specified size and location.
Public methodStatic member AddLinkLabel(ControlCollection, Range, String) Adds a new LinkLabel control to the worksheet at the range specified.
Public methodStatic member AddLinkLabel(ControlCollection, Double, Double, Double, Double, String) Adds a new LinkLabel control to the worksheet in the specified size and location.
Public methodStatic member AddListBox(ControlCollection, Range, String) Adds a new ListBox control to the worksheet at the range specified.
Public methodStatic member AddListBox(ControlCollection, Double, Double, Double, Double, String) Adds a new ListBox control to the worksheet in the specified size and location.
Public methodStatic member AddListView(ControlCollection, Range, String) Adds a new ListView control to the worksheet at the range specified.
Public methodStatic member AddListView(ControlCollection, Double, Double, Double, Double, String) Adds a new ListView control to the worksheet in the specified size and location.
Public methodStatic member AddMaskedTextBox(ControlCollection, Range, String) Adds a new MaskedTextBox control to the worksheet at the range specified.
Public methodStatic member AddMaskedTextBox(ControlCollection, Double, Double, Double, Double, String) Adds a new MaskedTextBox control to the document in the specified size and location.
Public methodStatic member AddMonthCalendar(ControlCollection, Range, String) Adds a new MonthCalendar control to the worksheet at the range specified.
Public methodStatic member AddMonthCalendar(ControlCollection, Double, Double, Double, Double, String) Adds a new MonthCalendar control to the worksheet in the specified size and location.
Public methodStatic member AddNumericUpDown(ControlCollection, Range, String) Adds a new NumericUpDown control to the worksheet at the range specified.
Public methodStatic member AddNumericUpDown(ControlCollection, Double, Double, Double, Double, String) Adds a new NumericUpDown control to the worksheet in the specified size and location.
Public methodStatic member AddPictureBox(ControlCollection, Range, String) Adds a new PictureBox control to the worksheet at the range specified.
Public methodStatic member AddPictureBox(ControlCollection, Double, Double, Double, Double, String) Adds a new PictureBox control to the worksheet in the specified size and location.
Public methodStatic member AddProgressBar(ControlCollection, Range, String) Adds a new ProgressBar control to the worksheet at the range specified.
Public methodStatic member AddProgressBar(ControlCollection, Double, Double, Double, Double, String) Adds a new ProgressBar control to the worksheet in the specified size and location.
Public methodStatic member AddPropertyGrid(ControlCollection, Range, String) Adds a new PropertyGrid control to the worksheet at the range specified.
Public methodStatic member AddPropertyGrid(ControlCollection, Double, Double, Double, Double, String) Adds a new PropertyGrid control to the worksheet in the specified size and location.
Public methodStatic member AddRadioButton(ControlCollection, Range, String) Adds a new RadioButton control to the worksheet at the range specified.
Public methodStatic member AddRadioButton(ControlCollection, Double, Double, Double, Double, String) Adds a new RadioButton control to the worksheet in the specified size and location.
Public methodStatic member AddRichTextBox(ControlCollection, Range, String) Adds a new RichTextBox control to the worksheet at the range specified.
Public methodStatic member AddRichTextBox(ControlCollection, Double, Double, Double, Double, String) Adds a new RichTextBox control to the worksheet in the specified size and location.
Public methodStatic member AddTextBox(ControlCollection, Range, String) Adds a new TextBox control to the worksheet at the range specified.
Public methodStatic member AddTextBox(ControlCollection, Double, Double, Double, Double, String) Adds a new TextBox control to the worksheet in the specified size and location.
Public methodStatic member AddTrackBar(ControlCollection, Range, String) Adds a new TrackBar control to the worksheet at the range specified.
Public methodStatic member AddTrackBar(ControlCollection, Double, Double, Double, Double, String) Adds a new TrackBar control to the worksheet in the specified size and location.
Public methodStatic member AddTreeView(ControlCollection, Range, String) Adds a new TreeView control to the worksheet at the range specified.
Public methodStatic member AddTreeView(ControlCollection, Double, Double, Double, Double, String) Adds a new TreeView control to the worksheet in the specified size and location.
Public methodStatic member AddVScrollBar(ControlCollection, Range, String) Adds a new VScrollBar control to the worksheet at the range specified.
Public methodStatic member AddVScrollBar(ControlCollection, Double, Double, Double, Double, String) Adds a new VScrollBar control to the worksheet in the specified size and location.
Public methodStatic member AddWebBrowser(ControlCollection, Range, String) Adds a new WebBrowser control to the worksheet at the range specified.
Public methodStatic member AddWebBrowser(ControlCollection, Double, Double, Double, Double, String) Adds a new WebBrowser control to the worksheet in the specified size and location.

Top

Remarks

The ControlExtensions methods are extension methods that are available on the ControlCollection object returned by the Worksheet.Controls property (in an application-level project) or the WorksheetBase.Controls property (in a document-level project) at run time. To add a specific control to a document, use the method that includes the name of the control in the method name. For example, to add a Button, use the AddButton method.

For more information about controls to a document, see Adding Controls to Office Documents at Run Time. For more information about extension methods, see Extension Methods (C# Programming Guide) and Extension Methods (Visual Basic).

Note

In Excel add-in projects that target the .NET Framework 4, you must add a reference to the Microsoft.Office.Tools.Excel.v4.0.Utilities.dll assembly before you can access the ControlExtensions methods.

Examples

The following code example uses the AddButton method to add a Button control to cell A1, and then adds text to the button. To use this example, run it from the Sheet1 class in a document-level project.

    Private Sub ExcelRangeAddButton()

        Dim Button1 As Microsoft.Office.Tools.Excel. _
          Controls.Button = Me.Controls.AddButton( _
          Me.Range("A1"), "Button1")
        Button1.Text = "OK"

    End Sub

private void ExcelRangeAddButton()
{

    Microsoft.Office.Tools.Excel.Controls.Button button1 =
        this.Controls.AddButton(this.Range["A1", missing], "button1");
    button1.Text = "OK";
}

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

See Also

Reference

Microsoft.Office.Tools.Excel Namespace