Using VBA to add tabs to a multipage useform in excel

vba excel userform multipage
Ehudz picture Ehudz · May 9, 2012 · Viewed 11.4k times · Source

I need to find the VBA code to add x number of tabs to a multipage in a userform in excel. I can manually add tabs if I use the visual basic editor, but I want to be able to dynamically add/delete tabs using VBA during runtime.

Thanks

Answer

Siddharth Rout picture Siddharth Rout · May 10, 2012

The Tabs in a MultiPage1 are called Pages and you can add them using

MultiPage1.Pages.Add

You can use the above code in a loop to add pages. Please refer to Excel's inbuilt help for more details

Edit:

Just saw the 2nd part of the question. To delete, say the 1st page use this

MultiPage1.Pages.Remove (0)

Related questions

How to dynamically get the value of current multipage tab value?

Community, I am currently hiding my tabs on my userform multipage except for the current tab. The user can click buttons to switch back and forth between pages. Some buttons share sub routines. When a user clicks a button, it …

Read More
Passing variable from Form to Module in VBA

I have the following button on a Form: Private Sub CommandButton1_Click() Dim pass As String pass = UserForm1.TextBox1 Unload UserForm1 End Sub I then have a Module called Module1: Public Sub Login() ... UserForm1.Show driver.findElementByName("PASSWORD").SendKeys pass ... …

Read More
Excel VBA Open workbook, perform actions, save as, close

This question has been edited due to lengthy comments and updates from proposed answers. As requested here is module 13; Sub SaveInFormat() Application.DisplayAlerts = False Workbooks.Application.ActiveWorkbook.SaveAs Filename:="C:\Documents and Settings\jammil\Desktop\AutoFinance\ProjectControl\Data\" & Format(…

Read More