Userform tab rows disappearing

bisel

Board Regular
Joined
Jan 4, 2010
Messages
233
Office Version
  1. 365
Platform
  1. Windows
Hello,

I have created a multipage userform that because of the number of pages and the caption for each tab end up with three tab rows (or button rows should one choose that option).

When the userform opens, initially it only displays two tab rows. But when you click on one of the tabs, then all three rows appear. Strangely enough, this same behavior occurs when I go to edit the userform.

Does anyone have a thought on why this occurs?

Thanks,

Steve
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Sorry I could not help you:
I asked one question:
I have never heard of a Tab Row

And you wanted me to click a link.
I'm still interested in what a Tab Row is
 
Upvote 0
with a multipage userform, there is a row of tabs across the top of the userform with the name of each tab corresponding to the caption name of the page. If one goes to the multipage properties, there is property called "Style". You can select tabs, buttons or none. There are other properties there which are self explanatory.

With the default properties for TabFixedHeight and TabFixedWidth set at 0, the tabs (or buttons) automatically adjust to accommodate the contents and they also will automatically set the number of rows that appear on the userform. Leaving this set to 0, is resulting in some of the rows disappearing until I click on tab or button. I have found that if you explicitly set the TabFixedHeight and TabFixedWidth, then the rows do not disappear and that is what I am doing now. I was hoping someone could tell me why leaving at the default of 0, the rows or buttons might disappear when opening the userform.

Steve
 
Upvote 0
I see what you have explained now. I have never used MultiRow Tabs

I will play with this and see what is happening. Will get back with you.
 
Upvote 0
I looked at this and all my tabs appeared every time. But it would be hard for me to give you a answer why yours do not.
At least I learned something new here today.
 
Upvote 0

Forum statistics

Threads
1,223,888
Messages
6,175,217
Members
452,619
Latest member
Shiv1198

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top