DateTimePicker Class

Definition

Namespace:

Microsoft.Office.Tools.Excel.Controls

Assembly:

Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

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

public ref class DateTimePicker : System::Windows::Forms::DateTimePicker

[System.ComponentModel.DefaultEvent("ValueChanged")]
[System.ComponentModel.DefaultProperty("Value")]
[System.ComponentModel.ToolboxItem(false)]
public class DateTimePicker : System.Windows.Forms.DateTimePicker

[<System.ComponentModel.DefaultEvent("ValueChanged")>]
[<System.ComponentModel.DefaultProperty("Value")>]
[<System.ComponentModel.ToolboxItem(false)>]
type DateTimePicker = class
    inherit DateTimePicker

Public Class DateTimePicker
Inherits DateTimePicker

Inheritance

DateTimePicker

DateTimePicker

Attributes

DefaultEventAttribute DefaultPropertyAttribute ToolboxItemAttribute

Remarks

The Microsoft.Office.Tools.Excel.Controls.DateTimePicker is different from a System.Windows.Forms.DateTimePicker. The Microsoft.Office.Tools.Excel.Controls.DateTimePicker 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 DateTimePicker. Use the AddDateTimePicker method to add a new DateTimePicker to a worksheet.

Properties

AltHTML
Application	Gets an Application object that represents the creator of the DateTimePicker.
Border	Gets a Border that represents the border of the DateTimePicker.
Bottom	Gets the distance, in points, between the bottom edge of the DateTimePicker 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 DateTimePicker.
Creator	Gets a value that indicates the application in which the DateTimePicker was created.
Height	Gets or sets the height of the DateTimePicker.
Index	Gets the index number of the DateTimePicker within the collection of OLEObjects on the sheet.
Interior	Gets an Interior object that represents the interior of the DateTimePicker.
Left	Gets or sets the distance, in points, between the left edge of the DateTimePicker and the left edge of the worksheet.
Locked	Gets or sets a value that indicates whether the DateTimePicker 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 DateTimePicker.
Placement	Gets or sets an object that indicates the way the DateTimePicker is attached to the cells below it.
PrintObject	Gets or sets a value that indicates whether the DateTimePicker is printed when the worksheet is printed.
Right	Gets the distance, in points, between the right edge of the DateTimePicker and the left edge of the worksheet.
ShapeRange	Gets a ShapeRange object that represents the DateTimePicker.
SourceName	Gets or sets the link source name of the DateTimePicker.
Top	Gets or sets the distance, in points, between the top edge of the DateTimePicker 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 DateTimePicker.
Visible	Gets or sets a value that represents whether the DateTimePicker is visible.
Width	Gets or sets the width of the DateTimePicker in points.
ZOrder	Gets the z-order position of the DateTimePicker.

Methods

Activate()	Activates the DateTimePicker.
BringToFront()	Brings the DateTimePicker to the front of the z-order.
CopyPicture(XlPictureAppearance, XlCopyPictureFormat)	Copies the DateTimePicker to the Clipboard as a picture.
Delete()	Deletes a dynamically created DateTimePicker from the worksheet and removes it from the ControlCollection.
Select(Object)	Selects the DateTimePicker.
SendToBack()	Sends the DateTimePicker to the back of the z-order.
SetVisibleCore(Boolean)	Sets the DateTimePicker to the specified visible state.
Update()