Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS Date Time Picker 6.0 question
Just wondering, is it safe to assume that the
Microsoft Date/Time Picker 6.0 Control will always start up with the current date??? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS Date Time Picker 6.0 question
I believe so, but the documentation doesn't mention it. To be sure, though,
you can just assign the date to it in the UserForm's Initialize event... DTPicker1.Value = Date -- Rick (MVP - Excel) "Robert Crandal" wrote in message ... Just wondering, is it safe to assume that the Microsoft Date/Time Picker 6.0 Control will always start up with the current date??? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
MS Date Time Picker 6.0 question
I think it will start up with whatever date is set in propertiesvalue
To make sure it is always current date and formatted as you like. Private Sub UserForm_Initialize() Calendar1.Value = Format(Date, "dd-mmm-yy") End Sub Gord Dibben MS Excel MVP On Fri, 25 Dec 2009 01:36:38 -0700, "Robert Crandal" wrote: Just wondering, is it safe to assume that the Microsoft Date/Time Picker 6.0 Control will always start up with the current date??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Time Picker | Excel Programming | |||
Date & Time Picker Properties Question | Excel Programming | |||
Microsoft Date and Time Picker Control 6.0 (SP6) question | Excel Discussion (Misc queries) | |||
Date and Time Picker | Excel Programming | |||
Set Value for Date/Time Picker | Excel Programming |