ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Creating an Object on a Multipage (https://www.excelbanter.com/excel-programming/318997-creating-object-multipage.html)

Michael[_35_]

Creating an Object on a Multipage
 
Hi, I creating a Excel VBA tipping competition.

I have code which allows me to enter create pages for a multipage
corresponding the amount that the user inputs / chooses with a
combobox. The thing is though that I am unable to add anything to
these multipages, which I will be using to input their names in the
corresponding tabs. i.e. player 1 has a textbox for name input all the
way up to player x.

I am using the following code to create the number of multipage pages,
and have a multipage with no pages invisible until this code is
activated.
x = ComboBox1.Value
For b = 1 To x
With MultiPage1
.Add "Player " & b
End With
Next b

Thanks,
Michael


All times are GMT +1. The time now is 12:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com