Distinguish the tabs for a multipage userform in VBA

Question

I saw the following question from another user:

Changing the colour of tabs of Multipage in VBA

and it talked about adding a checkmark to the active tab. I'm trying to find something other than that to implement if at all possible.

I actually found mention of a solution which described changing the color of the tabs at the following website:

https://www.mrexcel.com/board/threads/changing-the-font-back-colors-of-individual-tabs-pages-in-a-multipage.1158211/

but it involves a number of APIs and is rather involved. I'm looking for something perhaps a little simpler.

Answer 1

Okay ... I found a way to accomplish what I was looking to do. Normally tabs appear without anything much distinguishing them as shown below:

MultiPageTabsRegular

What I was able to do was make the tabs stand out a little as the following demonstrates:

MultiPageTabsEnhanced

This was accomplished by creating a few Labels with the following characteristics:

Delete the Caption

Height = 2

Top = 0

SpecialEffect = 1 – fmSpecialEffectRaised

This was the simplicity I was looking for!

Answer 2

There is no "code" to produce this effect. It's accomplished by creating the appropriate labels and positioning them accordingly.

Excel Tab UserForm Label 5

Excel Tab UserForm Label 6

Desired effect:

enter image description here