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
"jille" <jille[ at ]discussions.microsoft.com> wrote in message
news:CA4AA40B-FB64-44B4-B24B-1A295B30D050[ at ]microsoft.com...
[Quoted Text] > 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
|