![]() |
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? |
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? |
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