Code to avoid duplicate userforms

Hi,

I have a userform that has a control button that opens another userform that contains a listbox with a range of data. I want to click on an item and press a control button to add it to a textbox on my first userform. I do this via:

Please Login or Register  to view this content.

This works fine, but I need the same method for 5 seperate Multipages. Instead of creating 5 duplicate forms, is there a way of replacing tadnasname.Value with say the active textbox so I can just use one form?

Thank you in advance.

Personally I would work it the other way.

Rather than push the value from the userform to varying textboxes I would pull the value from the first userform.

Code in first userform

Please Login or Register  to view this content.

Code in second form

Please Login or Register  to view this content.