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?