Add page to TAB CONTROL

[Mihail]

Hi again !

I use MS OFFICE 2007.

When insert a TAB CONTROL (from the ribbon) in my form, it has 2 pages.
But I need more and I can not find a way to do that.

Any ideas ?

Thank you !

[TheSmileyCoder]

Been a while since I used tab controls. I believe you right click one of the existing page tabs to insert a new page.

[Mihail]

Ufffff TheSmileyCoder !!!!!!!!

YES. That is.

I expect to be an option in the PROPERTIES pane.

Your answer is the best, of course, but, because I "solve" somehow this task, see and wonder:

Create a new module (or use an existing one).
In that module place this code:

Private Sub AdPageToTABControl()
Dim frm As Form
Dim tbc As TabControl
 
    Set frm = Forms!Calcul 'Calcul is the name of my form. _
                    Use the form name, not VBA form name (Form_Calcul)
    Set tbc = frm!TabControl
 
'To add page:
    tbc.Pages.Add   'Add a page AFTER the last existing page
'   tbc.Pages.Add(Before)
 
'To remove page:
    tbc.Pages.Remove 'Remove the LAST page
'   tbc.Pages.Remove(Item)
End Sub

and RUN it.

This code work only if the form is in DESIGN mode. (?!?!?!)

Maybe someone else can find the utility of this code. Now, after your answer, the utility for me is NULL.

Thank you very very much !

[TheSmileyCoder]

Good to see you got it working.

The adding and removal of controls can only be done in design view. However you can change the visibility of individual tab pages at runtime. So depending on your needs should you need to modify the amount of tabpages at runtime, you could create extra tabs and simply hide them until needed. It is however not the most flexible approach.