Multi-Page Userform error switching pages

Are these "stand alone" UserForms, or forms on a spreadsheet? If stand alone, you can use Unload Userform1 Userform2.Show. Change the Userform names to what yours are to get them to work properly.

The Value of a Multipage is 0 based. i.e. if Value = 0 then page 1 is showing.

To loop through the pages without error you could use this. The Mod keeps the value within the required range

Please Login or Register  to view this content.

To Grey out

Please Login or Register  to view this content.

Originally Posted by mikerickson

To Grey out

Please Login or Register  to view this content.

Ok, thanks, just a couple of questions:

1) Why is there a dot/period in between Multi and Page? My Multipage is called Multipage2 - I took away the period sign but it hasn't worked so far.
2) Forgive my noobishness - both codes seem to contain Value +1 and Value - 1 and also CommandButton 1 and Command Button 2. Why is this?


UPDATE,

Have used the following with some success:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

I don't get any error messages BUT the next button greys out on the penultimate page rather than the last. If I then scroll to the very beginning, I'm finding both buttons greyed out and there's no way to move.

I'm sure I must have done something wrong, probably regarding the Command Button1 and Command Button 2 which I chaged to fit my private sub name.

Thanks again for your help.

Henry

Tom: Not sure I get the distinction?

I think using the term "stand alone" was not the correct way to describe what I was trying to convey. I think "pop-up" Userform might have been better. Meaning does your Userform open in it's own "pop-up" window, or is it in/on a worksheet?

1) The dot is a typo
2) I was hypothesizing a situation where CommandButton1 was Next and CommandButton2 was Previous. Each of them has to deal with the Enabled of both buttons. And I came up with a universal test for each that both routines used.

In both your two routines, you should change this line.

Please Login or Register  to view this content.

The greying out might be better driven by the MultiPage1_Change event rather than the Command Button code.

This is a straightforward solution that I've come up with. The reason for the Intialize event is to make sure that the Enabled properties are set right from the start.

Please Login or Register  to view this content.

The MOD function is only needed if one wants Next (or Back) to loop. Since your style is to disable inapplicable buttons, Mod is not needed.