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?

Robert,

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

HTH,
Bernie
MS Excel MVP


"Robert Crandal" wrote in message
...
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?

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.



"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
Robert,

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

HTH,
Bernie
MS Excel MVP