ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Problems with MS-DateTime-Picker 6.0 (https://www.excelbanter.com/excel-programming/438762-problems-ms-datetime-picker-6-0-a.html)

Robert Crandal

Problems with MS-DateTime-Picker 6.0
 
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

Problems with MS-DateTime-Picker 6.0
 
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?





Robert Crandal

Problems with MS-DateTime-Picker 6.0
 
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





All times are GMT +1. The time now is 02:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com