Userform TabStrip questions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Trefor - 28 Jan 2008 17:58 GMT

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?

Signature

Trefor

Reply to this Message

Jon Peltier - 29 Jan 2008 03:49 GMT

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
_______

>I am trying to design a form and I am using a TabStrip. Depending on what
>my
[quoted text clipped - 3 lines]
>
> Is it possible to add or remove a single tab on a TabStrip?

Reply to this Message

Trefor - 29 Jan 2008 07:20 GMT

Jon,

Excellent just what I needed, many thanks.

Trefor

Signature

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
[quoted text clipped - 24 lines]
> >
> > Is it possible to add or remove a single tab on a TabStrip?

Reply to this Message