Adds a new DateTimePicker control to the worksheet at the range specified.
(in Microsoft.Office.Tools.Excel.v9.0.dll)
Visual Basic (Declaration)
Public Function AddDateTimePicker ( _
range As Range, _
name As String _
) As DateTimePicker
Dim instance As ControlCollection
Dim range As Range
Dim name As String
Dim returnValue As DateTimePicker
returnValue = instance.AddDateTimePicker(range, _
name)
public DateTimePicker AddDateTimePicker(
Range range,
string name
)
The AddDateTimePicker method enables you to add DateTimePicker objects to the end of the ControlCollection. To remove a DateTimePicker that was previously added programmatically, use the Remove()()() method.
The control automatically resizes when the range is resized.
The following code example adds a DateTimePicker control to cells A1 through C1, and then sets the background of the calendar to light blue.
Private Sub ExcelRangeAddDateTimePicker()
Dim DateTimePicker1 As Microsoft.Office.Tools. _
Excel.Controls.DateTimePicker = Me.Controls. _
AddDateTimePicker(Me.Range("A1", "C1"), _
"DateTimePicker1")
DateTimePicker1.CalendarMonthBackground = _
Color.LightBlue
End Sub
private void ExcelRangeAddDateTimePicker()
{
Microsoft.Office.Tools.Excel.Controls.DateTimePicker
dateTimePicker1 = this.Controls.AddDateTimePicker(
this.Range["A1", "C1"], "dateTimePicker1");
dateTimePicker1.CalendarMonthBackground = Color.LightBlue;
}
Reference