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