Distinguish the tabs for a multipage userform in VBA

Question

I saw the following question from another user:

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:

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

Michael Riley · Answer 1 · 2022-09-03T21:22:15.477

0

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

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

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!

edited Sep 03 '22 at 21:22

answered Sep 03 '22 at 21:20

Michael Riley

Could you share your code to demonstrate how to make this work? – ALeXceL Sep 10 '22 at 14:34
As it’s currently written, your answer is unclear. Please [edit] to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Sep 15 '22 at 00:11

score 0 · Answer 2 · answered Sep 16 '22 at 19:30

0

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

Desired effect:

answered Sep 16 '22 at 19:30

Michael Riley

2 Answers2