ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Dynamically name MultiPage Pages (https://www.excelbanter.com/excel-programming/342942-dynamically-name-multipage-pages.html)

JakeyC

Dynamically name MultiPage Pages
 
I'm using the statement

UserForm1.MultiPage1.Page1.Caption = "whatever"

to name the pages of my Multipage.

I want to use a loop to name pages 1 through 20 similar to:

While j < 20

UserForm1.MultiPage1.Page & j & .Caption = "whatever"

j = j + 1

Wend

But that is apparently not the right syntax or maybe concatenating j as
an integer is wrong?

Regards
JakeyC


JakeyC

Dynamically name MultiPage Pages
 
I think I have it!

....

PageTitle = "Page" & j

With Backcheck.MultiPage1.Pages(PageTitle)
..Caption = "Whatever"

....



All times are GMT +1. The time now is 02:48 AM.

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