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 |
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