I am trying to design a form and I am using a TabStrip. Depending on what my
code determines I would like to set the number of tabs in the code.

Is it possible to Enable / Make visible a single tab on a TabStrip?

Is it possible to add or remove a single tab on a TabStrip?

--
Trefor

To test this I created a userform, added a tab strip and two command
buttons. One button adds a new tab at the end, the other removes the last
tab. Here is the code for the buttons:

Private Sub AddButton_Click()
Me.TabStrip1.Tabs.Add
End Sub

Private Sub SubtractButton_Click()
If Me.TabStrip1.Tabs.Count 1 Then
Me.TabStrip1.Tabs.Remove Me.TabStrip1.Tabs.Count - 1
End If
End Sub

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Trefor" wrote in message
...
I am trying to design a form and I am using a TabStrip. Depending on what
my
code determines I would like to set the number of tabs in the code.

Is it possible to Enable / Make visible a single tab on a TabStrip?

Is it possible to add or remove a single tab on a TabStrip?

--
Trefor

Jon,

Excellent just what I needed, many thanks.

Trefor

--
Trefor


"Jon Peltier" wrote:

To test this I created a userform, added a tab strip and two command
buttons. One button adds a new tab at the end, the other removes the last
tab. Here is the code for the buttons:

Private Sub AddButton_Click()
Me.TabStrip1.Tabs.Add
End Sub

Private Sub SubtractButton_Click()
If Me.TabStrip1.Tabs.Count 1 Then
Me.TabStrip1.Tabs.Remove Me.TabStrip1.Tabs.Count - 1
End If
End Sub

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Trefor" wrote in message
...
I am trying to design a form and I am using a TabStrip. Depending on what
my
code determines I would like to set the number of tabs in the code.

Is it possible to Enable / Make visible a single tab on a TabStrip?

Is it possible to add or remove a single tab on a TabStrip?

--
Trefor