MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Userform with MultiPages


Posted by Fred on October 01, 2001 11:41 PM

I have created a Multipage UserForm with two tabs (the default). I would like to add three more pages to it. It doesnt have to be done programatically, once they are created, they will remain. Is there a property somewhere that controls the number of pages ? I havnet been able to find one Thanks for the help.


Posted by Dank on October 02, 2001 12:21 AM

Just right click the tab and choose New Page. You can add one programatically like this:-

Private Sub UserForm_Click()
Me.TabStrip1.Tabs.Add , "Added by macro"
End Sub

Regards,
Daniel.