Change UserForm to MultiPage

[adambc]

I have a (single page) UserForm that works fine, but I need to change it to a MultiPage form ...

Is there an easy way to do this?

Thanks ...

 

[sijpie]

Excel VBA MultiPage Control in Userforms | Computergaga

The Excel VBA Multipage Control is a useful way of logically grouping the controls on your Excel VBA userforms into separate tabs, or pages.

www.computergaga.com

Userform with Multiple Pages in Excel VBA

Learn how to create a program in Excel VBA which creates a Userform that contains multiple pages. This userform also contains images.

www.excel-easy.com

UserForm MultiPage Control. Excel Training VBA 2 lesson 8

UserForm MultiPage Control. Excel Training VBA 2 lesson 8

www.ozgrid.com

 

[adambc]

@sijpie - thanks but not quite what I'm looking for ...

I know how to create MultiPage UserForms if I'm starting from scratch, but I have an existing UserForm that following new User requirements, really should be a MultiPage UserForm and I cannot see an easy way to make the existing form Page 1 and create Page 2 from scratch ...

Any other takers please ...

Thanks ...

 

[sijpie]

I don't fully understand your problem. There is no difference between a one page form or a multi page form. It is just a lay-out issue.
The code for each of the controls stays exactly the same. It is only the user who sees a different layout.

So if you have a working single page userform, then I suggest you (temporarily) make the userform larger. Then add the multipage object onto the form. Now move the controls to the pages where you want them. Then move or expand the multipage and run the form to check the user logic is OK