I want to combine three word projects and one spreadsheet into a single user experience. I thought Multipage was the ticket, but I am unable to initiate any sub by clicking any of the named tabs.

Ideally when the user invokes the word document, the user will see four tabs: "Vendor List", "Partial Waiver", "Final Waiver" and "Notary". The "Vendor List" invokes a spreadsheet. The other three invoke separate word 2016 document templates I've developed. The user should be able to select any tab, and in any any order.



Never had a need for Multipage or a tab strip before. Cannot get them to work the way I expect. Clicking on the tab itself does nothing. The tutorials I've read use either the form activate() event or an action somewhere within the Excel spreadsheet. (I cannot find anything for a word document.)

Is the Multipage or Tab Strip control the proper approach? Or is there a better option

I've only used MultiPage once, but the idea is to have separate pages -- dialog boxes -- in the userform for each tab. The old wizards were multi-page userforms.

You need to set actions in your userform for the click event for each control. Is your userform going to be set to be modeless?

Here is my Add-In that uses the MultiPage. Bar Code Add-In You are welcome to examine the code. (Note, the Add-In is not really functional, but the tabs work.)

Take a look at:

• Should I use a MultiPage or a TabStrip? | Microsoft Docs
• Dialog boxes (Microsoft Forms) | Microsoft Docs
• Userforms – Advanced Notes & Tips
• Create a Simple Userform by Graham Mayor, MVP
• Create & Employ a Userform by Greg Maxey
• Interactive Userforms

Thank you Charles Kenyon

How did you get your page tabs to trigger an event?

I downloaded your code and find that the setting for my multipage properties are the same as yours. But clicking on the tab on yours triggers an event. Mine does not.

I was unable to run the application through the developer window, so do am not able not see what event gets triggered. Nor do I find any reference in the code for "Page".

Your code does work the way I envisioned mine to work. Being self-taught, there's clearly a fundamental concept I'm missing.

My Plan B is to use layer forms (subforming?) to see if I can achieve the same result.

My control is a Multi-Page. The tabs just trigger moving to the page for the tab and that is a part of the control. No special code is needed. Take a look at the properties for each page.

When editing the form, I can add a page by right-clicking at the top of the MultiPage control. That page becomes visible by clicking on the tab at the top for the page. This is a function of the control itself.

The MultiPage control gives a completely separate dialog page with its own controls. On mine, the MultiPage control is covering only part of the form with some controls being visible no matter what page is being displayed. The underlying code for the userform can respond to the controls on all the pages, so you can use it for sequential settings.
Here is another page from Microsoft. MultiPage control | Microsoft Docs
Most of the writing on the web is about Excel vba, but for forms, I think it is pretty much the same.
Here is a Stack Overflow question on using code to switch pages: excel - How to select/open a page available under a Multipage (Userform) using VBA code - Stack Overflow

When I put a control on one of the multipage tabs, it activated both of them.

One of those famous Microsoft "Undocumented Features". But, then, who but me would try testing out the control with nothing on it?

(The properties are fine.)

Thanks for your followup, Charles Kenyon