Help with VBA Form sizing

[peter_z]

Hey guys

If you have any code that could help me out of this tricky situation it would be much appreciated and it would make my Friday!

I have a form in vba with two tabs.
Both the tabs are different sizes.

The first tab is quite large and the 2nd tab is smaller.

When I click the 2nd tab it shrinks the form but then when I click back to the first form it makes it the same size and the 2nd tab and cutting out key info.

Is there anyway I can resize the 1st tab again to go back to its original size?

Thanks heaps for your help

 

[Norie]

Do you mean a tabstrip control on a userform?

They can't have tabs of different sizes.

 

[peter_z]

Hi Norie, it is the tabstrip.

If you know how to refer to the tabstrip it might solve my problem.

Cheers!

 

[Norie]

Not sure what you mean about referring to the tabstrip.

However I think I know what might be happening.

The tabs appear to change size based on the controls associated with them.

I'll need to check that out though.

In the meantime why not try a multitab instead of a tabstrip.