ControlCollection.AddNumericUpDown Method (Double, Double, Double, Double, String)

Adds a new NumericUpDown control to the worksheet in the specified size and location.

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


Public Function AddNumericUpDown ( _
    left As Double, _
    top As Double, _
    width As Double, _
    height As Double, _
    name As String _
) As NumericUpDown
Dim instance As ControlCollection
Dim left As Double
Dim top As Double
Dim width As Double
Dim height As Double
Dim name As String
Dim returnValue As NumericUpDown

returnValue = instance.AddNumericUpDown(left, _
    top, width, height, name)
public NumericUpDown AddNumericUpDown(
    double left,
    double top,
    double width,
    double height,
    string name


  • left
    Type: System.Double
    The distance in points between the left edge of the control and the left edge of the worksheet.
  • top
    Type: System.Double
    The distance in points between the top edge of the control and the top edge of the worksheet.
  • height
    Type: System.Double
    The height of the control in points.

Return Value

Type: Microsoft.Office.Tools.Excel.Controls.NumericUpDown
The NumericUpDown control that was added to the ControlCollection instance.


Exception Condition

The name argument is nulla null reference (Nothing in Visual Basic) or has zero length.


A control with the same name is already in the ControlCollection instance.


The AddNumericUpDown method enables you to add NumericUpDown objects to the end of the ControlCollection. To remove a NumericUpDown control that was previously added programmatically, use the Remove() method.


The following code example adds a NumericUpDown control to the top of the worksheet, and then sets the value to 10.

    Private Sub ExcelAddNumericUpDown()

        Dim NumericUpDown1 As Microsoft.Office.Tools. _
            Excel.Controls.NumericUpDown = Me.Controls. _
            AddNumericUpDown(0, 0, 60, 15, "NumericUpDown1")
        NumericUpDown1.Value = 10

    End Sub

private void ExcelAddNumericUpDown()

         numericUpDown1 = this.Controls.AddNumericUpDown(
         0, 0, 60, 15, "numericUpDown1");
    numericUpDown1.Value = 10;

.NET Framework Security

See Also


ControlCollection Class

ControlCollection Members

AddNumericUpDown Overload

Microsoft.Office.Tools.Excel Namespace