Tabstrip Usage

AlexanderBB

Well-known Member
Joined
Jul 1, 2009
Messages
1,950
Office Version
  1. 2019
  2. 2016
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

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
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
Thank Micron, finally got it. Now if feels easy... weird!
 
Upvote 0
Glad I could help & thanks for the recognition!
 
Upvote 0

Forum statistics

Threads
1,221,310
Messages
6,159,176
Members
451,543
Latest member
cesymcox

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