VBA Line to Send Userform Info to Parent Userform Textbox

Hello Forum,

Thanks in advance for your help.

I have a userform (call it "Child") that has a multitude of listboxes and a few textboxes that I'd like to pop up from a primary userform (call it "Parent"), allow the user to make their selections and entries in Child, then send those entries back to a specific textbox (call it "TxtBx") on the the Parent userform.

I already have code (thanks to this Forum!) that takes the multiselect listbox selections and textbox entries from Child and combines them into a Dim text string called "Selections". Currently it's set up to populate a specific cell in my Excel spreadsheet:

Worksheets("Sheet1").Range("E48").Value = Selections

My requirements have changed and now I need it to populate the Parent textbox as described above, which I will then send to the spreadsheet cell.

Is this possible and, if so, how do I modify this text destination coding to accomplish this?

Again, appreciate your time and help.

Regards,
Chris

Hi and thanks for the quick response Leith.

This is where my ignorance shines. Couple questions:

"Selections" is set within a Private Sub for a command button as:

Dim Selections As String

How do declare it as a Public Variable in a module? Do I simply change it to:

Public Selections As String

and move it to the top of that module? And will it still work in the command button coding?

Also, I should have mentioned that my "Parent" userform is a multipage userform and the textbox is on page 3. Knowing that, would the proper code for assigning to the textbox be:

UserForm1.MultiPage1.Page3.TextBox1.Value = Selections

Again, your help is appreciated. Chris