Multipage Userform

[begoldar]

Hi Everyone,

I have a multipage userform that activates pages based upon an option button the user selects. ie: select option 1, takes user to page 2, select option 2, takes user to page 3.... In these pages there are text boxes which the user has to fill out. Unfortunately, two pages are exactly the same (user needs to fill out same data.) So, rather than make my code really ugly by having every box with a unique name, I was hoping there's a way to clean things up. So:

Is it possible to have the 2 of the inital option buttons take the user to the same page?

Or

Rather than take the user the same page, is it possible to have the two pages use the same text boxes? (That way, I only have to name them once)

Thanks!

 

[Smitty]

I've used something like this in the past with seperate Billing & Shipping information pages:

<font face=Courier New><SPAN style="color:#00007F">Private</SPAN> <SPAN style="color:#00007F">Sub</SPAN> CommandButton6_Click()
    <SPAN style="color:#007F00">' Copy Address Fields</SPAN>
    <SPAN style="color:#00007F">For</SPAN> i = 40 <SPAN style="color:#00007F">To</SPAN> 51
        Me.Controls("tb" & i).Value = Me.Controls("tb" & i - 18).Value
    <SPAN style="color:#00007F">Next</SPAN> i
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

Using a button to populate shipping data with the billing data.

Hope that helps,

Smitty

 

[begoldar]

what do i 40-51 represent?

 

[Smitty]

The code is looping from Text Box (tb) 40 to 51.

The controls in that form are numbered sequentially, so in this case on MP1 they're numbered 16-33 and on MP2 they're numbered 34-51. I'm capturing information from tb's 22-33 and putting it in corresponding tb's 40-51.

I'd be happy to send you a copy of it.

Smitty

 

[begoldar]

Oh ok. Unfortunately each of my textboxes has a unique name (so that I can recognize it in the code). Is there a way to modify your code so that it would recognize these names? Or do I have to write a line of code for each text box? Thanks again for the help!

 

[Smitty]

That's one of the problems with naming them like that.

Offhand (meaning it's Friday and I'm brain dead), I can't think of a way to do it without specifically referring to them if that's the naming convention you used.

Smitty