| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Dynamically name MultiPage Pages
I think I have it!
.... PageTitle = "Page" & j With Backcheck.MultiPage1.Pages(PageTitle) ..Caption = "Whatever" .... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing subset of pages dynamically using excel macros | Excel Discussion (Misc queries) | |||
| Multipage Control Pages - Changing Index Value in Code | Excel Programming | |||
| Multipage Control Pages - Changing Index Value in Code | Excel Programming | |||
| how to make a multipage with many pages all of which can be seen easily. | Excel Programming | |||
| Displaying different pages in MultiPage | Excel Programming | |||
Linear Mode
