Problems with MS-DateTime-Picker 6.0

[Robert Crandal]

My userform has a Multipage control on top. My
Microsoft Date-Time-Picker 6.0 Control is sitting
on "Page 1" of the Multi-page control. If I change
to "Page 2" and try to access the ".Value" of the
DTPicker control, it will return an error value.
(It is returning the year 1899).

What is wrong here? Does the DTPicker need to
be on the visible page to be used?? Are there any
other things I should know about this DTPicker control?

 

[Bernie Deitrick]

Robert,

You could assign the DTPicker's value to a public date variable in its
change event.

HTH,
Bernie
MS Excel MVP

 

[Robert Crandal]

Ok, I will give that a try.....

It's just odd to me that the DTPicker seems to be the only control
which has a vanishing value if it's placed on a multi-page that isn't
visible or active.