Command Buttons on Userform

[PaulWJ]

I have a multipage Userform which has 9 tabs at the top. The tabs are selected based on a number of options (they prompt a user to ask specific questions based on different scenarios). Essentially, however, they all do the same thing - check the questions have been answered correctly.

I can add Command Buttons on each (Confirm, Cancel, Clear & Other), but each needs it's own private sub, which runs on the 'click' of each button. I've done one tab, but is here any way to replicate the code on the buttons on the other tabs (rather than having the same four bits of code replicated 9 times?

 

[RoryA]

Is it basically the same code (or logic) for every page?

 

[jkpieterse]

Why not put the buttons outside of the multipage?

 

[PaulWJ]

Yes Rory, it is.

JK - honestly, because I didn't know I could do that First stab at a multipage userform and still finding my way round. I'll give that a go.

 

[jkpieterse]

Paul: You can use the Value property of the multipage to get the page number (zero indexed) and have the buttons act accordingly..

 

[PaulWJ]

Thanks both. I will have a play and see what I can do. If I need more help, I'll be back.