View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JakeyC JakeyC is offline
external usenet poster
 
Posts: 107
Default 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