Concatenate textbox and label values inside UF

Hello -

I have a user form that contains multiple pages. I need to concatenate the values entered in text boxes on page 1, page 3 and a label displayed on page 5 into a single textbox displayed on page 7. I've attached a sample workbook with a UF that details what I need to achieve. If anyone can help me with the code for this it would be appreciated.

Thanks!

Hi Grilleman,

Try the following (tested and working):

Please Login or Register  to view this content.

I would suggest that you rename the TextBoxes and Labels so you know which page they are supposed to be on. For Example TextBox2 on page 3 might be renamed to 'TextBoxP3Country'.

To rename a control, access the Properties window (F4) while in UserForm Design Mode, and then modify the '(Name)' attribute in the Properties Window.

Lewis