DateTimePicker Class

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

Inheritance Hierarchy

System.Object
  System.MarshalByRefObject
    System.ComponentModel.Component
      System.Windows.Forms.Control
        System.Windows.Forms.DateTimePicker
          Microsoft.Office.Tools.Excel.Controls.DateTimePicker

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

Syntax

'Declaration
<PermissionSetAttribute(SecurityAction.Demand, Name := "FullTrust")> _
Public Class DateTimePicker _
    Inherits DateTimePicker

[PermissionSetAttribute(SecurityAction.Demand, Name = "FullTrust")]
public class DateTimePicker : DateTimePicker

The DateTimePicker type exposes the following members.

Constructors

	Name	Description
	DateTimePicker()	Infrastructure.
	DateTimePicker(Factory, IHostItemProvider, IServiceProvider, String, String, Object, String)	Infrastructure.

Top

Properties

	Name	Description
	AccessibilityObject	Gets the AccessibleObject assigned to the control. (Inherited from Control.)
	AccessibleDefaultActionDescription	Gets or sets the default action description of the control for use by accessibility client applications. (Inherited from Control.)
	AccessibleDescription	Gets or sets the description of the control used by accessibility client applications. (Inherited from Control.)
	AccessibleName	Gets or sets the name of the control used by accessibility client applications. (Inherited from Control.)
	AccessibleRole	Gets or sets the accessible role of the control (Inherited from Control.)
	AllowDrop	Gets or sets a value indicating whether the control can accept data that the user drags onto it. (Inherited from Control.)
	AltHTML	Infrastructure.
	Anchor	Infrastructure. (Overrides Control.Anchor.)
	Application	Gets an Application object that represents the creator of the DateTimePicker.
	AutoScrollOffset	Gets or sets where this control is scrolled to in ScrollControlIntoView. (Inherited from Control.)
	AutoSize	Infrastructure. This property is not relevant for this class. (Inherited from Control.)
	BackColor	Gets or sets a value indicating the background color of the DateTimePicker control. (Inherited from DateTimePicker.)
	BackgroundImage	Infrastructure. Gets or sets the background image for the control. (Inherited from DateTimePicker.)
	BackgroundImageLayout	Infrastructure. Gets or sets the layout of the background image of the DateTimePicker control. (Inherited from DateTimePicker.)
	BindingContext	Gets or sets the BindingContext for the control. (Inherited from Control.)
	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.
	Bounds	Gets or sets the size and location of the control including its nonclient elements, in pixels, relative to the parent control. (Inherited from Control.)
	CalendarFont	Gets or sets the font style applied to the calendar. (Inherited from DateTimePicker.)
	CalendarForeColor	Gets or sets the foreground color of the calendar. (Inherited from DateTimePicker.)
	CalendarMonthBackground	Gets or sets the background color of the calendar month. (Inherited from DateTimePicker.)
	CalendarTitleBackColor	Gets or sets the background color of the calendar title. (Inherited from DateTimePicker.)
	CalendarTitleForeColor	Gets or sets the foreground color of the calendar title. (Inherited from DateTimePicker.)
	CalendarTrailingForeColor	Gets or sets the foreground color of the calendar trailing dates. (Inherited from DateTimePicker.)
	CanEnableIme	Gets a value indicating whether the ImeMode property can be set to an active value, to enable IME support. (Inherited from Control.)
	CanFocus	Gets a value indicating whether the control can receive focus. (Inherited from Control.)
	CanRaiseEvents	Determines if events can be raised on the control. (Inherited from Control.)
	CanSelect	Gets a value indicating whether the control can be selected. (Inherited from Control.)
	Capture	Gets or sets a value indicating whether the control has captured the mouse. (Inherited from Control.)
	CausesValidation	Gets or sets a value indicating whether the control causes validation to be performed on any controls that require validation when it receives focus. (Inherited from Control.)
	Checked	Gets or sets a value indicating whether the Value property has been set with a valid date/time value and the displayed value is able to be updated. (Inherited from DateTimePicker.)
	ClientRectangle	Gets the rectangle that represents the client area of the control. (Inherited from Control.)
	ClientSize	Gets or sets the height and width of the client area of the control. (Inherited from Control.)
	CompanyName	Gets the name of the company or creator of the application containing the control. (Inherited from Control.)
	Container	Gets the IContainer that contains the Component. (Inherited from Component.)
	ContainsFocus	Gets a value indicating whether the control, or one of its child controls, currently has the input focus. (Inherited from Control.)
	ContextMenu	Gets or sets the shortcut menu associated with the control. (Inherited from Control.)
	ContextMenuStrip	Gets or sets the ContextMenuStrip associated with this control. (Inherited from Control.)
	Controls	Gets the collection of controls contained within the control. (Inherited from Control.)
	Created	Gets a value indicating whether the control has been created. (Inherited from Control.)
	CreateParams	Returns the CreateParams used to create this window. (Inherited from DateTimePicker.)
	Creator	Gets a value that indicates the application in which the DateTimePicker was created.
	Cursor	Gets or sets the cursor that is displayed when the mouse pointer is over the control. (Inherited from Control.)
	CustomFormat	Gets or sets the custom date/time format string. (Inherited from DateTimePicker.)
	DataBindings	Gets the data bindings for the control. (Inherited from Control.)
	DefaultCursor	Gets or sets the default cursor for the control. (Inherited from Control.)
	DefaultImeMode	Gets the default Input Method Editor (IME) mode supported by the control. (Inherited from Control.)
	DefaultMargin	Gets the space, in pixels, that is specified by default between controls. (Inherited from Control.)
	DefaultMaximumSize	Gets the length and height, in pixels, that is specified as the default maximum size of a control. (Inherited from Control.)
	DefaultMinimumSize	Gets the length and height, in pixels, that is specified as the default minimum size of a control. (Inherited from Control.)
	DefaultPadding	Gets the internal spacing, in pixels, of the contents of a control. (Inherited from Control.)
	DefaultSize	Gets the default size of the control. (Inherited from DateTimePicker.)
	DesignMode	Gets a value that indicates whether the Component is currently in design mode. (Inherited from Component.)
	DisplayRectangle	Gets the rectangle that represents the display area of the control. (Inherited from Control.)
	Disposing	Gets a value indicating whether the base Control class is in the process of disposing. (Inherited from Control.)
	Dock	Infrastructure. (Overrides Control.Dock.)
	DoubleBuffered	Infrastructure. Gets or sets a value indicating whether the control should redraw its surface using a secondary buffer. Setting this property has no effect on the DateTimePicker control. (Inherited from DateTimePicker.)
	DropDownAlign	Gets or sets the alignment of the drop-down calendar on the DateTimePicker control. (Inherited from DateTimePicker.)
	Enabled	Gets or sets a value indicating whether the control can respond to user interaction. (Inherited from Control.)
	Events	Gets the list of event handlers that are attached to this Component. (Inherited from Component.)
	Focused	Gets a value indicating whether the control has input focus. (Inherited from Control.)
	Font	Gets or sets the font of the text displayed by the control. (Inherited from Control.)
	FontHeight	Gets or sets the height of the font of the control. (Inherited from Control.)
	ForeColor	Infrastructure. Gets or sets the foreground color of the DateTimePicker control. (Inherited from DateTimePicker.)
	Format	Gets or sets the format of the date and time displayed in the control. (Inherited from DateTimePicker.)
	Handle	Gets the window handle that the control is bound to. (Inherited from Control.)
	HasChildren	Gets a value indicating whether the control contains one or more child controls. (Inherited from Control.)
	Height	Gets or sets the height of the DateTimePicker.
	ImeMode	Gets or sets the Input Method Editor (IME) mode of the control. (Inherited from Control.)
	ImeModeBase	Gets or sets the IME mode of a control. (Inherited from Control.)
	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.
	InvokeRequired	Gets a value indicating whether the caller must call an invoke method when making method calls to the control because the caller is on a different thread than the one the control was created on. (Inherited from Control.)
	IsAccessible	Gets or sets a value indicating whether the control is visible to accessibility applications. (Inherited from Control.)
	IsDisposed	Gets a value indicating whether the control has been disposed of. (Inherited from Control.)
	IsHandleCreated	Gets a value indicating whether the control has a handle associated with it. (Inherited from Control.)
	IsMirrored	Gets a value indicating whether the control is mirrored. (Inherited from Control.)
	LayoutEngine	Gets a cached instance of the control's layout engine. (Inherited from Control.)
	Left	Gets or sets the distance, in points, between the left edge of the DateTimePicker and the left edge of the worksheet.
	Location	Infrastructure.
	Locked	Gets or sets a value that indicates whether the DateTimePicker can be modified at design time when the sheet is protected.
	Margin	Gets or sets the space between controls. (Inherited from Control.)
	MaxDate	Gets or sets the maximum date and time that can be selected in the control. (Inherited from DateTimePicker.)
	MaximumSize	Gets or sets the size that is the upper limit that GetPreferredSize can specify. (Inherited from Control.)
	MinDate	Gets or sets the minimum date and time that can be selected in the control. (Inherited from DateTimePicker.)
	MinimumSize	Gets or sets the size that is the lower limit that GetPreferredSize can specify. (Inherited from Control.)
	Name	Gets or sets the name of the control. (Inherited from Control.)
	OLEType	Gets a value that represents the OLE object type.
	OnAction	Infrastructure.
	Padding	Infrastructure. Gets or sets the spacing between the contents of the DateTimePicker control and its edges. (Inherited from DateTimePicker.)
	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.
	PreferredHeight	Gets the preferred height of the DateTimePicker control. (Inherited from DateTimePicker.)
	PreferredSize	Gets the size of a rectangular area into which the control can fit. (Inherited from Control.)
	PrintObject	Gets or sets a value that indicates whether the DateTimePicker is printed when the worksheet is printed.
	ProductName	Gets the product name of the assembly containing the control. (Inherited from Control.)
	ProductVersion	Gets the version of the assembly containing the control. (Inherited from Control.)
	RecreatingHandle	Gets a value indicating whether the control is currently re-creating its handle. (Inherited from Control.)
	Region	Gets or sets the window region associated with the control. (Inherited from Control.)
	RenderRightToLeft	Obsolete. This property is now obsolete. (Inherited from Control.)
	ResizeRedraw	Gets or sets a value indicating whether the control redraws itself when resized. (Inherited from Control.)
	Right	Gets the distance, in points, between the right edge of the DateTimePicker and the left edge of the worksheet.
	RightToLeft	Gets or sets a value indicating whether control's elements are aligned to support locales using right-to-left fonts. (Inherited from Control.)
	RightToLeftLayout	Gets or sets whether the contents of the DateTimePicker are laid out from right to left. (Inherited from DateTimePicker.)
	ScaleChildren	Gets a value that determines the scaling of child controls. (Inherited from Control.)
	ShapeRange	Gets a Microsoft.Office.Interop.Excel.ShapeRange object that represents the DateTimePicker.
	ShowCheckBox	Gets or sets a value indicating whether a check box is displayed to the left of the selected date. (Inherited from DateTimePicker.)
	ShowFocusCues	Gets a value indicating whether the control should display focus rectangles. (Inherited from Control.)
	ShowKeyboardCues	Gets a value indicating whether the user interface is in the appropriate state to show or hide keyboard accelerators. (Inherited from Control.)
	ShowUpDown	Gets or sets a value indicating whether a spin button control (also known as an up-down control) is used to adjust the date/time value. (Inherited from DateTimePicker.)
	Site	Gets or sets the site of the control. (Inherited from Control.)
	Size	Gets or sets the height and width of the control. (Inherited from Control.)
	SourceName	Gets or sets the link source name of the DateTimePicker.
	TabIndex	Infrastructure.
	TabStop	Infrastructure.
	Tag	Gets or sets the object that contains data about the control. (Inherited from Control.)
	Text	Gets or sets the text associated with this control. (Inherited from 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.
	TopLevelControl	Infrastructure.
	UseWaitCursor	Gets or sets a value indicating whether to use the wait cursor for the current control and all child controls. (Inherited from Control.)
	Value	Gets or sets the date/time value assigned to the control. (Inherited from 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.
	WindowTarget	Infrastructure. This property is not relevant for this class. (Inherited from Control.)
	ZOrder	Gets the z-order position of the DateTimePicker.

Top

Methods

	Name	Description
	AccessibilityNotifyClients(AccessibleEvents, Int32)	Notifies the accessibility client applications of the specified AccessibleEvents for the specified child control. (Inherited from Control.)
	AccessibilityNotifyClients(AccessibleEvents, Int32, Int32)	Notifies the accessibility client applications of the specified AccessibleEvents for the specified child control . (Inherited from Control.)
	Activate	Activates the DateTimePicker.
	BeginInvoke(Delegate)	Executes the specified delegate asynchronously on the thread that the control's underlying handle was created on. (Inherited from Control.)
	BeginInvoke(Delegate, array<Object[])	Executes the specified delegate asynchronously with the specified arguments, on the thread that the control's underlying handle was created on. (Inherited from Control.)
	BringToFront	Brings the DateTimePicker to the front of the z-order.
	Contains	Retrieves a value indicating whether the specified control is a child of the control. (Inherited from Control.)
	CopyPicture	Copies the DateTimePicker to the Clipboard as a picture.
	CreateAccessibilityInstance	Infrastructure. Creates a new accessibility object for the DateTimePicker control. (Inherited from DateTimePicker.)
	CreateControl	Forces the creation of the visible control, including the creation of the handle and any visible child controls. (Inherited from Control.)
	CreateControlsInstance	Creates a new instance of the control collection for the control. (Inherited from Control.)
	CreateGraphics	Creates the Graphics for the control. (Inherited from Control.)
	CreateHandle	Creates the physical window handle. (Inherited from DateTimePicker.)
	CreateObjRef	Security Critical. Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object. (Inherited from MarshalByRefObject.)
	DefWndProc	Sends the specified message to the default window procedure. (Inherited from Control.)
	Delete	Deletes a dynamically created DateTimePicker from the worksheet and removes it from the ControlCollection.
	DestroyHandle	Destroys the physical window handle. (Inherited from DateTimePicker.)
	Dispose()	Releases all resources used by the Component. (Inherited from Component.)
	Dispose(Boolean)	Releases the unmanaged resources used by the DateTimePicker and optionally releases the managed resources. (Overrides Control.Dispose(Boolean).)
	DoDragDrop	Begins a drag-and-drop operation. (Inherited from Control.)
	DrawToBitmap	Supports rendering to the specified bitmap. (Inherited from Control.)
	EndInvoke	Retrieves the return value of the asynchronous operation represented by the IAsyncResult passed. (Inherited from Control.)
	Equals	Determines whether the specified object is equal to the current object. (Inherited from Object.)
	Finalize	Releases unmanaged resources and performs other cleanup operations before the Component is reclaimed by garbage collection. (Inherited from Component.)
	FindForm	Retrieves the form that the control is on. (Inherited from Control.)
	Focus	Sets input focus to the control. (Inherited from Control.)
	GetAccessibilityObjectById	Retrieves the specified AccessibleObject. (Inherited from Control.)
	GetAutoSizeMode	Retrieves a value indicating how a control will behave when its AutoSize property is enabled. (Inherited from Control.)
	GetChildAtPoint(Point)	Retrieves the child control that is located at the specified coordinates. (Inherited from Control.)
	GetChildAtPoint(Point, GetChildAtPointSkip)	Retrieves the child control that is located at the specified coordinates, specifying whether to ignore child controls of a certain type. (Inherited from Control.)
	GetContainerControl	Returns the next ContainerControl up the control's chain of parent controls. (Inherited from Control.)
	GetHashCode	Serves as the default hash function. (Inherited from Object.)
	GetLifetimeService	Security Critical. Retrieves the current lifetime service object that controls the lifetime policy for this instance. (Inherited from MarshalByRefObject.)
	GetNextControl	Retrieves the next control forward or back in the tab order of child controls. (Inherited from Control.)
	GetPreferredSize	Retrieves the size of a rectangular area into which a control can be fitted. (Inherited from Control.)
	GetScaledBounds	Retrieves the bounds within which the control is scaled. (Inherited from Control.)
	GetService	Returns an object that represents a service provided by the Component or by its Container. (Inherited from Component.)
	GetStyle	Retrieves the value of the specified control style bit for the control. (Inherited from Control.)
	GetTopLevel	Determines if the control is a top-level control. (Inherited from Control.)
	GetType	Gets the Type of the current instance. (Inherited from Object.)
	Hide	Conceals the control from the user. (Inherited from Control.)
	InitializeLifetimeService	Security Critical. Obtains a lifetime service object to control the lifetime policy for this instance. (Inherited from MarshalByRefObject.)
	InitLayout	Called after the control has been added to another container. (Inherited from Control.)
	Invalidate()	Invalidates the entire surface of the control and causes the control to be redrawn. (Inherited from Control.)
	Invalidate(Region)	Invalidates the specified region of the control (adds it to the control's update region, which is the area that will be repainted at the next paint operation), and causes a paint message to be sent to the control. (Inherited from Control.)
	Invalidate(Boolean)	Invalidates a specific region of the control and causes a paint message to be sent to the control. Optionally, invalidates the child controls assigned to the control. (Inherited from Control.)
	Invalidate(Rectangle)	Invalidates the specified region of the control (adds it to the control's update region, which is the area that will be repainted at the next paint operation), and causes a paint message to be sent to the control. (Inherited from Control.)
	Invalidate(Region, Boolean)	Invalidates the specified region of the control (adds it to the control's update region, which is the area that will be repainted at the next paint operation), and causes a paint message to be sent to the control. Optionally, invalidates the child controls assigned to the control. (Inherited from Control.)
	Invalidate(Rectangle, Boolean)	Invalidates the specified region of the control (adds it to the control's update region, which is the area that will be repainted at the next paint operation), and causes a paint message to be sent to the control. Optionally, invalidates the child controls assigned to the control. (Inherited from Control.)
	Invoke(Delegate)	Executes the specified delegate on the thread that owns the control's underlying window handle. (Inherited from Control.)
	Invoke(Delegate, array<Object[])	Executes the specified delegate, on the thread that owns the control's underlying window handle, with the specified list of arguments. (Inherited from Control.)
	InvokeGotFocus	Raises the GotFocus event for the specified control. (Inherited from Control.)
	InvokeLostFocus	Raises the LostFocus event for the specified control. (Inherited from Control.)
	InvokeOnClick	Raises the Click event for the specified control. (Inherited from Control.)
	InvokePaint	Raises the Paint event for the specified control. (Inherited from Control.)
	InvokePaintBackground	Raises the PaintBackground event for the specified control. (Inherited from Control.)
	IsInputChar	Determines if a character is an input character that the control recognizes. (Inherited from Control.)
	IsInputKey	Determines whether the specified key is a regular input key or a special key that requires preprocessing. (Inherited from DateTimePicker.)
	MemberwiseClone()	Creates a shallow copy of the current Object. (Inherited from Object.)
	MemberwiseClone(Boolean)	Creates a shallow copy of the current MarshalByRefObject object. (Inherited from MarshalByRefObject.)
	NotifyInvalidate	Infrastructure. Raises the Invalidated event with a specified region of the control to invalidate. (Inherited from Control.)
	OnAutoSizeChanged	Raises the AutoSizeChanged event. (Inherited from Control.)
	OnBackColorChanged	Raises the BackColorChanged event. (Inherited from Control.)
	OnBackgroundImageChanged	Raises the BackgroundImageChanged event. (Inherited from Control.)
	OnBackgroundImageLayoutChanged	Raises the BackgroundImageLayoutChanged event. (Inherited from Control.)
	OnBindingContextChanged	Raises the BindingContextChanged event. (Inherited from Control.)
	OnCausesValidationChanged	Raises the CausesValidationChanged event. (Inherited from Control.)
	OnChangeUICues	Raises the ChangeUICues event. (Inherited from Control.)
	OnClick	Raises the Click event. (Inherited from Control.)
	OnClientSizeChanged	Raises the ClientSizeChanged event. (Inherited from Control.)
	OnCloseUp	Raises the CloseUp event. (Inherited from DateTimePicker.)
	OnContextMenuChanged	Raises the ContextMenuChanged event. (Inherited from Control.)
	OnContextMenuStripChanged	Raises the ContextMenuStripChanged event. (Inherited from Control.)
	OnControlAdded	Raises the ControlAdded event. (Inherited from Control.)
	OnControlRemoved	Raises the ControlRemoved event. (Inherited from Control.)
	OnCreateControl	Raises the CreateControl method. (Inherited from Control.)
	OnCursorChanged	Raises the CursorChanged event. (Inherited from Control.)
	OnDockChanged	Raises the DockChanged event. (Inherited from Control.)
	OnDoubleClick	Raises the DoubleClick event. (Inherited from Control.)
	OnDragDrop	Raises the DragDrop event. (Inherited from Control.)
	OnDragEnter	Raises the DragEnter event. (Inherited from Control.)
	OnDragLeave	Raises the DragLeave event. (Inherited from Control.)
	OnDragOver	Raises the DragOver event. (Inherited from Control.)
	OnDropDown	Raises the DropDown event. (Inherited from DateTimePicker.)
	OnEnabledChanged	Raises the EnabledChanged event. (Inherited from Control.)
	OnEnter	Raises the Enter event. (Inherited from Control.)
	OnFontChanged	Infrastructure. Raises the FontChanged event. (Inherited from DateTimePicker.)
	OnForeColorChanged	Raises the ForeColorChanged event. (Inherited from Control.)
	OnFormatChanged	Raises the FormatChanged event. (Inherited from DateTimePicker.)
	OnGiveFeedback	Raises the GiveFeedback event. (Inherited from Control.)
	OnGotFocus	Raises the GotFocus event. (Inherited from Control.)
	OnHandleCreated	Raises the HandleCreated event. (Inherited from DateTimePicker.)
	OnHandleDestroyed	Raises the HandleDestroyed event. (Inherited from DateTimePicker.)
	OnHelpRequested	Raises the HelpRequested event. (Inherited from Control.)
	OnImeModeChanged	Raises the ImeModeChanged event. (Inherited from Control.)
	OnInvalidated	Raises the Invalidated event. (Inherited from Control.)
	OnKeyDown	Raises the KeyDown event. (Inherited from Control.)
	OnKeyPress	Raises the KeyPress event. (Inherited from Control.)
	OnKeyUp	Raises the KeyUp event. (Inherited from Control.)
	OnLayout	Raises the Layout event. (Inherited from Control.)
	OnLeave	Raises the Leave event. (Inherited from Control.)
	OnLocationChanged	Raises the LocationChanged event. (Inherited from Control.)
	OnLostFocus	Raises the LostFocus event. (Inherited from Control.)
	OnMarginChanged	Raises the MarginChanged event. (Inherited from Control.)
	OnMouseCaptureChanged	Raises the MouseCaptureChanged event. (Inherited from Control.)
	OnMouseClick	Raises the MouseClick event. (Inherited from Control.)
	OnMouseDoubleClick	Raises the MouseDoubleClick event. (Inherited from Control.)
	OnMouseDown	Raises the MouseDown event. (Inherited from Control.)
	OnMouseEnter	Raises the MouseEnter event. (Inherited from Control.)
	OnMouseHover	Raises the MouseHover event. (Inherited from Control.)
	OnMouseLeave	Raises the MouseLeave event. (Inherited from Control.)
	OnMouseMove	Raises the MouseMove event. (Inherited from Control.)
	OnMouseUp	Raises the MouseUp event. (Inherited from Control.)
	OnMouseWheel	Raises the MouseWheel event. (Inherited from Control.)
	OnMove	Raises the Move event. (Inherited from Control.)
	OnNotifyMessage	Notifies the control of Windows messages. (Inherited from Control.)
	OnPaddingChanged	Raises the PaddingChanged event. (Inherited from Control.)
	OnPaint	Raises the Paint event. (Inherited from Control.)
	OnPaintBackground	Paints the background of the control. (Inherited from Control.)
	OnParentBackColorChanged	Raises the BackColorChanged event when the BackColor property value of the control's container changes. (Inherited from Control.)
	OnParentBackgroundImageChanged	Raises the BackgroundImageChanged event when the BackgroundImage property value of the control's container changes. (Inherited from Control.)
	OnParentBindingContextChanged	Raises the BindingContextChanged event when the BindingContext property value of the control's container changes. (Inherited from Control.)
	OnParentChanged	Raises the ParentChanged event. (Inherited from Control.)
	OnParentCursorChanged	Raises the CursorChanged event. (Inherited from Control.)
	OnParentEnabledChanged	Raises the EnabledChanged event when the Enabled property value of the control's container changes. (Inherited from Control.)
	OnParentFontChanged	Raises the FontChanged event when the Font property value of the control's container changes. (Inherited from Control.)
	OnParentForeColorChanged	Raises the ForeColorChanged event when the ForeColor property value of the control's container changes. (Inherited from Control.)
	OnParentRightToLeftChanged	Raises the RightToLeftChanged event when the RightToLeft property value of the control's container changes. (Inherited from Control.)
	OnParentVisibleChanged	Raises the VisibleChanged event when the Visible property value of the control's container changes. (Inherited from Control.)
	OnPreviewKeyDown	Raises the PreviewKeyDown event. (Inherited from Control.)
	OnPrint	Raises the Paint event. (Inherited from Control.)
	OnQueryContinueDrag	Raises the QueryContinueDrag event. (Inherited from Control.)
	OnRegionChanged	Raises the RegionChanged event. (Inherited from Control.)
	OnResize	Raises the Resize event. (Inherited from Control.)
	OnRightToLeftChanged	Raises the RightToLeftChanged event. (Inherited from Control.)
	OnRightToLeftLayoutChanged	Raises the RightToLeftLayout event. (Inherited from DateTimePicker.)
	OnSizeChanged	Raises the SizeChanged event. (Inherited from Control.)
	OnStyleChanged	Raises the StyleChanged event. (Inherited from Control.)
	OnSystemColorsChanged	Infrastructure. Overrides the OnSystemColorsChanged method. (Inherited from DateTimePicker.)
	OnTabIndexChanged	Raises the TabIndexChanged event. (Inherited from Control.)
	OnTabStopChanged	Raises the TabStopChanged event. (Inherited from Control.)
	OnTextChanged	Raises the TextChanged event. (Inherited from Control.)
	OnValidated	Raises the Validated event. (Inherited from Control.)
	OnValidating	Raises the Validating event. (Inherited from Control.)
	OnValueChanged	Raises the ValueChanged event. (Inherited from DateTimePicker.)
	OnVisibleChanged	Raises the VisibleChanged event. (Inherited from Control.)
	PerformLayout()	Forces the control to apply layout logic to all its child controls. (Inherited from Control.)
	PerformLayout(Control, String)	Forces the control to apply layout logic to all its child controls. (Inherited from Control.)
	PointToClient	Computes the location of the specified screen point into client coordinates. (Inherited from Control.)
	PointToScreen	Computes the location of the specified client point into screen coordinates. (Inherited from Control.)
	PreProcessControlMessage	Preprocesses keyboard or input messages within the message loop before they are dispatched. (Inherited from Control.)
	PreProcessMessage	Preprocesses keyboard or input messages within the message loop before they are dispatched. (Inherited from Control.)
	ProcessCmdKey	Processes a command key. (Inherited from Control.)
	ProcessDialogChar	Processes a dialog character. (Inherited from Control.)
	ProcessDialogKey	Processes a dialog key. (Inherited from Control.)
	ProcessKeyEventArgs	Processes a key message and generates the appropriate control events. (Inherited from Control.)
	ProcessKeyMessage	Processes a keyboard message. (Inherited from Control.)
	ProcessKeyPreview	Previews a keyboard message. (Inherited from Control.)
	ProcessMnemonic	Processes a mnemonic character. (Inherited from Control.)
	RaiseDragEvent	Infrastructure. Raises the appropriate drag event. (Inherited from Control.)
	RaiseKeyEvent	Infrastructure. Raises the appropriate key event. (Inherited from Control.)
	RaiseMouseEvent	Infrastructure. Raises the appropriate mouse event. (Inherited from Control.)
	RaisePaintEvent	Infrastructure. Raises the appropriate paint event. (Inherited from Control.)
	RecreateHandle	Forces the re-creation of the handle for the control. (Inherited from Control.)
	RectangleToClient	Computes the size and location of the specified screen rectangle in client coordinates. (Inherited from Control.)
	RectangleToScreen	Computes the size and location of the specified client rectangle in screen coordinates. (Inherited from Control.)
	Refresh	Forces the control to invalidate its client area and immediately redraw itself and any child controls. (Inherited from Control.)
	ResetBackColor	Resets the BackColor property to its default value. (Inherited from Control.)
	ResetBindings	Causes a control bound to the BindingSource to reread all the items in the list and refresh their displayed values. (Inherited from Control.)
	ResetCursor	Resets the Cursor property to its default value. (Inherited from Control.)
	ResetFont	Resets the Font property to its default value. (Inherited from Control.)
	ResetForeColor	Resets the ForeColor property to its default value. (Inherited from Control.)
	ResetImeMode	Resets the ImeMode property to its default value. (Inherited from Control.)
	ResetMouseEventArgs	Infrastructure. Resets the control to handle the MouseLeave event. (Inherited from Control.)
	ResetRightToLeft	Resets the RightToLeft property to its default value. (Inherited from Control.)
	ResetText	Resets the Text property to its default value. (Inherited from Control.)
	ResumeLayout()	Resumes usual layout logic. (Inherited from Control.)
	ResumeLayout(Boolean)	Resumes usual layout logic, optionally forcing an immediate layout of pending layout requests. (Inherited from Control.)
	RtlTranslateAlignment(HorizontalAlignment)	Converts the specified HorizontalAlignment to the appropriate HorizontalAlignment to support right-to-left text. (Inherited from Control.)
	RtlTranslateAlignment(LeftRightAlignment)	Converts the specified LeftRightAlignment to the appropriate LeftRightAlignment to support right-to-left text. (Inherited from Control.)
	RtlTranslateAlignment(ContentAlignment)	Converts the specified ContentAlignment to the appropriate ContentAlignment to support right-to-left text. (Inherited from Control.)
	RtlTranslateContent	Converts the specified ContentAlignment to the appropriate ContentAlignment to support right-to-left text. (Inherited from Control.)
	RtlTranslateHorizontal	Converts the specified HorizontalAlignment to the appropriate HorizontalAlignment to support right-to-left text. (Inherited from Control.)
	RtlTranslateLeftRight	Converts the specified LeftRightAlignment to the appropriate LeftRightAlignment to support right-to-left text. (Inherited from Control.)
	Scale(Single)	Obsolete. Scales the control and any child controls. (Inherited from Control.)
	Scale(SizeF)	Scales the control and all child controls by the specified scaling factor. (Inherited from Control.)
	Scale(Single, Single)	Obsolete. Scales the entire control and any child controls. (Inherited from Control.)
	ScaleControl	Scales a control's location, size, padding and margin. (Inherited from Control.)
	ScaleCore	Infrastructure. This method is not relevant for this class. (Inherited from Control.)
	Select()	Activates the control. (Inherited from Control.)
	Select(Object)	Selects the DateTimePicker.
	Select(Boolean, Boolean)	Activates a child control. Optionally specifies the direction in the tab order to select the control from. (Inherited from Control.)
	SelectNextControl	Activates the next control. (Inherited from Control.)
	SendToBack	Sends the DateTimePicker to the back of the z-order.
	SetAutoSizeMode	Sets a value indicating how a control will behave when its AutoSize property is enabled. (Inherited from Control.)
	SetBounds(Int32, Int32, Int32, Int32)	Infrastructure.
	SetBounds(Int32, Int32, Int32, Int32, BoundsSpecified)	Infrastructure.
	SetBoundsCore	Performs the work of setting the specified bounds of this control. (Inherited from Control.)
	SetClientSizeCore	Sets the size of the client area of the control. (Inherited from Control.)
	SetStyle	Sets a specified ControlStyles flag to either true or false. (Inherited from Control.)
	SetTopLevel	Sets the control as the top-level control. (Inherited from Control.)
	SetVisibleCore	Sets the DateTimePicker to the specified visible state. (Overrides Control.SetVisibleCore(Boolean).)
	Show	Displays the control to the user. (Inherited from Control.)
	SizeFromClientSize	Determines the size of the entire control from the height and width of its client area. (Inherited from Control.)
	SuspendLayout	Temporarily suspends the layout logic for the control. (Inherited from Control.)
	ToString	Infrastructure. Returns a string that represents the current DateTimePicker control. (Inherited from DateTimePicker.)
	Update	Infrastructure.
	UpdateBounds()	Updates the bounds of the control with the current size and location. (Inherited from Control.)
	UpdateBounds(Int32, Int32, Int32, Int32)	Updates the bounds of the control with the specified size and location. (Inherited from Control.)
	UpdateBounds(Int32, Int32, Int32, Int32, Int32, Int32)	Updates the bounds of the control with the specified size, location, and client size. (Inherited from Control.)
	UpdateStyles	Forces the assigned styles to be reapplied to the control. (Inherited from Control.)
	UpdateZOrder	Updates the control in its parent's z-order. (Inherited from Control.)
	WndProc	Infrastructure. Overrides the WndProc method. (Inherited from DateTimePicker.)

Top

Events

	Name	Description
	AutoSizeChanged	Infrastructure. This event is not relevant for this class. (Inherited from Control.)
	BackColorChanged	Infrastructure. Occurs when the value of the BackColor property changes. (Inherited from DateTimePicker.)
	BackgroundImageChanged	Infrastructure. Occurs when the value of the BackgroundImage property changes. (Inherited from DateTimePicker.)
	BackgroundImageLayoutChanged	Infrastructure. Occurs when the value of the BackgroundImageLayout property changes. (Inherited from DateTimePicker.)
	BindingContextChanged	Occurs when the value of the BindingContext property changes. (Inherited from Control.)
	CausesValidationChanged	Occurs when the value of the CausesValidation property changes. (Inherited from Control.)
	ChangeUICues	Occurs when the focus or keyboard user interface (UI) cues change. (Inherited from Control.)
	Click	Infrastructure. Occurs when the control is clicked. (Inherited from DateTimePicker.)
	ClientSizeChanged	Occurs when the value of the ClientSize property changes. (Inherited from Control.)
	CloseUp	Occurs when the drop-down calendar is dismissed and disappears. (Inherited from DateTimePicker.)
	ContextMenuChanged	Occurs when the value of the ContextMenu property changes. (Inherited from Control.)
	ContextMenuStripChanged	Occurs when the value of the ContextMenuStrip property changes. (Inherited from Control.)
	ControlAdded	Occurs when a new control is added to the Control.ControlCollection. (Inherited from Control.)
	ControlRemoved	Occurs when a control is removed from the Control.ControlCollection. (Inherited from Control.)
	CursorChanged	Occurs when the value of the Cursor property changes. (Inherited from Control.)
	Disposed	Occurs when the component is disposed by a call to the Dispose method. (Inherited from Component.)
	DockChanged	Occurs when the value of the Dock property changes. (Inherited from Control.)
	DoubleClick	Infrastructure. Occurs when the control is double-clicked. (Inherited from DateTimePicker.)
	DragDrop	Occurs when a drag-and-drop operation is completed. (Inherited from Control.)
	DragEnter	Occurs when an object is dragged into the control's bounds. (Inherited from Control.)
	DragLeave	Occurs when an object is dragged out of the control's bounds. (Inherited from Control.)
	DragOver	Occurs when an object is dragged over the control's bounds. (Inherited from Control.)
	DropDown	Occurs when the drop-down calendar is shown. (Inherited from DateTimePicker.)
	EnabledChanged	Occurs when the Enabled property value has changed. (Inherited from Control.)
	Enter	Occurs when the control is entered. (Inherited from Control.)
	FontChanged	Occurs when the Font property value changes. (Inherited from Control.)
	ForeColorChanged	Infrastructure. Occurs when the value of the ForeColor property changes. (Inherited from DateTimePicker.)
	FormatChanged	Occurs when the Format property value has changed. (Inherited from DateTimePicker.)
	GiveFeedback	Occurs during a drag operation. (Inherited from Control.)
	GotFocus	Occurs when the control receives focus. (Inherited from Control.)
	HandleCreated	Occurs when a handle is created for the control. (Inherited from Control.)
	HandleDestroyed	Occurs when the control's handle is in the process of being destroyed. (Inherited from Control.)
	HelpRequested	Occurs when the user requests help for a control. (Inherited from Control.)
	ImeModeChanged	Occurs when the ImeMode property has changed. (Inherited from Control.)
	Invalidated	Occurs when a control's display requires redrawing. (Inherited from Control.)
	KeyDown	Occurs when a key is pressed while the control has focus. (Inherited from Control.)
	KeyPress	Occurs when a key is pressed while the control has focus. (Inherited from Control.)
	KeyUp	Occurs when a key is released while the control has focus. (Inherited from Control.)
	Layout	Occurs when a control should reposition its child controls. (Inherited from Control.)
	Leave	Occurs when the input focus leaves the control. (Inherited from Control.)
	LocationChanged	Occurs when the Location property value has changed. (Inherited from Control.)
	LostFocus	Occurs when the control loses focus. (Inherited from Control.)
	MarginChanged	Occurs when the control's margin changes. (Inherited from Control.)
	MouseCaptureChanged	Occurs when the control loses mouse capture. (Inherited from Control.)
	MouseClick	Infrastructure. Occurs when the control is clicked with the mouse. (Inherited from DateTimePicker.)
	MouseDoubleClick	Infrastructure. Occurs when the control is double-clicked with the mouse. (Inherited from DateTimePicker.)
	MouseDown	Occurs when the mouse pointer is over the control and a mouse button is pressed. (Inherited from Control.)
	MouseEnter	Occurs when the mouse pointer enters the control. (Inherited from Control.)
	MouseHover	Occurs when the mouse pointer rests on the control. (Inherited from Control.)
	MouseLeave	Occurs when the mouse pointer leaves the control. (Inherited from Control.)
	MouseMove	Occurs when the mouse pointer is moved over the control. (Inherited from Control.)
	MouseUp	Occurs when the mouse pointer is over the control and a mouse button is released. (Inherited from Control.)
	MouseWheel	Occurs when the mouse wheel moves while the control has focus. (Inherited from Control.)
	Move	Occurs when the control is moved. (Inherited from Control.)
	PaddingChanged	Infrastructure. Occurs when the value of the Padding property changes. (Inherited from DateTimePicker.)
	Paint	Infrastructure. Occurs when the control is redrawn. (Inherited from DateTimePicker.)
	ParentChanged	Occurs when the Parent property value changes. (Inherited from Control.)
	PreviewKeyDown	Occurs before the KeyDown event when a key is pressed while focus is on this control. (Inherited from Control.)
	QueryAccessibilityHelp	Occurs when AccessibleObject is providing help to accessibility applications. (Inherited from Control.)
	QueryContinueDrag	Occurs during a drag-and-drop operation and enables the drag source to determine whether the drag-and-drop operation should be canceled. (Inherited from Control.)
	RegionChanged	Occurs when the value of the Region property changes. (Inherited from Control.)
	Resize	Occurs when the control is resized. (Inherited from Control.)
	RightToLeftChanged	Occurs when the RightToLeft property value changes. (Inherited from Control.)
	RightToLeftLayoutChanged	Occurs when the RightToLeftLayout property changes. (Inherited from DateTimePicker.)
	SizeChanged	Occurs when the Size property value changes. (Inherited from Control.)
	StyleChanged	Occurs when the control style changes. (Inherited from Control.)
	SystemColorsChanged	Occurs when the system colors change. (Inherited from Control.)
	TabIndexChanged	Occurs when the TabIndex property value changes. (Inherited from Control.)
	TabStopChanged	Occurs when the TabStop property value changes. (Inherited from Control.)
	TextChanged	Infrastructure. Occurs when the value of the Text property changes. (Inherited from DateTimePicker.)
	Validated	Occurs when the control is finished validating. (Inherited from Control.)
	Validating	Occurs when the control is validating. (Inherited from Control.)
	ValueChanged	Occurs when the Value property changes. (Inherited from DateTimePicker.)
	VisibleChanged	Occurs when the Visible property value changes. (Inherited from Control.)

Top

Explicit Interface Implementations

	Name	Description
	IDropTarget.OnDragDrop	Infrastructure. Raises the DragDrop event. (Inherited from Control.)
	IDropTarget.OnDragEnter	Infrastructure. Raises the DragEnter event. (Inherited from Control.)
	IDropTarget.OnDragLeave	Infrastructure. Raises the DragLeave event. (Inherited from Control.)
	IDropTarget.OnDragOver	Infrastructure. Raises the DragOver event. (Inherited from Control.)

Top

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.

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.Controls Namespace