Hi,
I have a multipage control on my userform that consists of 9 pages.
I want to do an error check when the user changes pages to ensure that they
have entered the data correctly. Sounds simple enough!
I thought that the Change event would be appropriate to determine when they
have changed the page but I'm having difficulty determining which page they
were on in the first place.
I know how to find the page index, and I thought of assigning a variable to
identify the current page but I don't know when/how to assign it...because
the user could be simply clicking from tab to tab without doing anything on
the page.
It made sense to me to assign the variable to an event, but pages don't have
any, so then I thought there might be some property that could be helpful.
Any help would be greatly appreciated...or perhaps I need to try a different
methodology?
Thanks
Shauna Kelly - 20 Sep 2006 15:51 GMT
Hi
One way to cope with this is to hide the tabs (put them on the right, and
then make the form narrower than the multipage). Then, provide the user with
Previous and Next buttons (place them on the form outside the multipage).
Now, write some code in the Next button's Click event that:
(a) determines the .Value of the multipage (that tells you what page the
user is on)
(b) does the validation for that page and gives the user any required
messages
(c) if and only if the data is valid, changes the .Value of the multipage
(to move on to the next page)
(d) hides the Next button if there is no next page.
And, do roughly vice-versa for the Previous button.
Hope this helps.
Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word
> Hi,
>
[quoted text clipped - 26 lines]
>
> Thanks