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