Date Picker Error in another page using Userform Multipage

Hi All,

I have 2 set of date pickers in userform Multipage.
The 1st page is "DTPicker1.Value" and in 2nd page is "DTPicker2.Value"

I want to ensure date in 2nd page must be greater than date in the 1st page.
On 2nd page when user click on the date, it should compare both dates but it does not work.

Please Login or Register  to view this content.

The issue is how to define/call date picker in another page??
I have tried this code, "Me.MultiPage1.Pages(0).DTPicker1.Value" but not working.

can anyone help me?

you shouldn't need to refer to the Page it's located I wouldn't have thought however I don't often use Date Pickers.

You should be able to use (without needing to format)

Please Login or Register  to view this content.

Also your argument should be <=

Hi PFDave,

Me.DTPicker1.Value will only work in the same page, or in single Userform without multipage.


Now, assume I am at 2nd page, I need to call back date picker in the 1st page. Upon searching in other forum, I found some people suggested to use

Please Login or Register  to view this content.

but still not working.


If this work "Me.DTPicker1.Value" , can you post sample workbook to me?

Hi PFDave and Others,

Here is sample of my workbook. Appreciate if could help to make it work

https://app.box.com/s/wpjo9z2cgayyugs56lqwumvpc7mooaaf


I have 2 issues
-----------------
1) How to call back date picker in multipage (in different page) both "Me.DTPicker1.Value" and "Me.MultiPage1.Pages(0).DTPicker1.Value" not working

2) When comparison failed, I wonder why the 1st date selected changed back to TODAY().