Tabstrip Usage

AlexanderBB

Well-known Member
Joined
Jul 1, 2009
Messages
2,099
Office Version
  1. 2019
  2. 2010
Platform
  1. Windows
I have tabstrip1 on my form and want to add 2 more tabs to it.
I've been hours hunting and can't find anything. All sorts of dead ends about right clicking and "Add New" but that doesn't seem to exist.
Double clicking opens the code editor, not any menu
And there's nothing useful in tabstrip1 properties, not even a Number of Count of tabs.
But in design mode there's 8 individual tabs, some even have captions but nowhere can I find where/how these are defined.
I can only see where the existing tabs are given new captions.
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
First you select and should see a selection border that looks like a grid of fine dots. Then left click a second time (assuming you use left button as primary) and selection border should change to hash lines (slanted lines). Do not double click to get here. Then right click and choose New Page.
 
Upvote 0
After selecting,I get the fine dots and the mouse turns to a 4pointer shape if I hover on them. There's also 3 white handles left and right for resizing.
A 2nd left click does nothing unless I hold it down, then I see the hash lines, But at that point I can't right click as I'm holding the left button down.
Release and right click brings up Cut -Copy-Paste-Delete-Propeties-View Code-Align-MakeSame Size-Bring Forward-Backwards.
Nothing seems to offer a New page.
 
Upvote 0
Just in case it was something odd in the Workbook, I tried a new Excel\Userform but its the same.
From Google, Double-click at the right side of the tabstrip, in the attributes there is a field with the number of tabs, incrementation of this value will create another tab.
What do they mean by 'right side'? Everywhere I click goes to the Change event code.
Is there any other way to reach this attributes field ?
 
Upvote 0
left click #1
1722914548126.png


left click #2 (on a tab, or on the strip - not the spotted border:
1722914632075.png


Right click on the strip (or tab) - not the border
1722914675099.png
 
Upvote 0
Solution
Glad I could help & thanks for the recognition!
 
Upvote 0

Forum statistics

Threads
1,224,822
Messages
6,181,165
Members
453,021
Latest member
Justyna P

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