Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / September 2006

Tip: Looking for answers? Try searching our database.

Page/MultiPage Control

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jille - 19 Sep 2006 17:04 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.