Compartilhar via

NumericUpDown Class

  • Reference

Definition

Namespace:
Microsoft.Office.Tools.Excel.Controls
Assembly:
Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

Represents a Windows Forms NumericUpDown that can be added to a Microsoft Office Excel worksheet.

public ref class NumericUpDown : System::Windows::Forms::NumericUpDown
[System.ComponentModel.DefaultEvent("ValueChanged")]
[System.ComponentModel.DefaultProperty("Value")]
[System.ComponentModel.ToolboxItem(false)]
public class NumericUpDown : System.Windows.Forms.NumericUpDown
[<System.ComponentModel.DefaultEvent("ValueChanged")>]
[<System.ComponentModel.DefaultProperty("Value")>]
[<System.ComponentModel.ToolboxItem(false)>]
type NumericUpDown = class
    inherit NumericUpDown
Public Class NumericUpDown
Inherits NumericUpDown
Inheritance
NumericUpDown
NumericUpDown
Attributes
DefaultEventAttribute DefaultPropertyAttribute ToolboxItemAttribute

Remarks

The Microsoft.Office.Tools.Excel.Controls.NumericUpDown is different from a System.Windows.Forms.NumericUpDown. The Microsoft.Office.Tools.Excel.Controls.NumericUpDown has additional members that enable it to be added to an Excel worksheet and that give it additional methods and properties.

Do not use the New constructor to create a new NumericUpDown. Use the AddNumericUpDown method to add a new NumericUpDown to a worksheet.

Properties

AltHTML
Application

Gets an Application object that represents the creator of the NumericUpDown.
Border

Gets a Border that represents the border of the NumericUpDown.
Bottom

Gets the distance, in points, between the bottom edge of the NumericUpDown and the top edge of the worksheet.
BottomRightCell

Gets a Range object that represents the cell that lies under the lower-right corner of the NumericUpDown.
Creator

Gets a value that indicates the application in which the NumericUpDown was created.
Height

Gets or sets the height of the NumericUpDown.
Index

Gets the index number of the NumericUpDown within the collection of OLEObjects on the sheet.
Interior

Gets an Interior object that represents the interior of the NumericUpDown.
Left

Gets or sets the distance, in points, between the left edge of the NumericUpDown and the left edge of the worksheet.
Locked

Gets or sets a value that indicates whether the NumericUpDown can be modified at design time when the sheet is protected.
OLEType

Gets a value that represents the OLE object type.
OnAction
Parent

Gets the parent object for the NumericUpDown.
Placement

Gets or sets an object that indicates the way the NumericUpDown is attached to the cells below it.
PrintObject

Gets or sets a value that indicates whether the NumericUpDown is printed when the worksheet is printed.
Right

Gets the distance, in points, between the right edge of the NumericUpDown and the left edge of the worksheet.
ShapeRange

Gets a ShapeRange object that represents the NumericUpDown.
SourceName

Gets or sets the link source name of the NumericUpDown.
Top

Gets or sets the distance, in points, between the top edge of the NumericUpDown and the top edge of the worksheet.
TopLeftCell

Gets a Range object that represents the cell that lies under the upper-left corner of the NumericUpDown.
Visible

Gets or sets a value that represents whether the NumericUpDown is visible.
Width

Gets or sets the width of the NumericUpDown in points.
ZOrder

Gets the z-order position of the NumericUpDown.

Methods

Activate()

Activates the NumericUpDown.
BringToFront()

Brings the NumericUpDown to the front of the z-order.
CopyPicture(XlPictureAppearance, XlCopyPictureFormat)

Copies the NumericUpDown to the Clipboard as a picture.
Delete()

Deletes a dynamically created NumericUpDown from the worksheet and removes it from the ControlCollection.
Select(Object)

Selects the NumericUpDown.
SendToBack()

Sends the NumericUpDown to the back of the z-order.
SetVisibleCore(Boolean)

Sets the NumericUpDown to the specified visible state.
Update()

Applies to