'Object Required' error Trying To Populate Textbox In One Userform With The Selected Value From Listbox in Second Userform (Xposted)

[Ark68]

I have hit a roadblock in the progress of my VBA project. I am reaching out to a second group of pros to see if perhaps they have a solution after having limited success where I had originally posted my question.

I have two open userforms. userform1 (uf3_group_1) has a textbox (textbox1) in which I am trying to populate from the listbox (miss_rn) selection from userform2 (miss_rn).

I am failing with this line in the initialization code of userform1.

TextBox1.Value = test_mr.miss_rn.ListIndex

This attempt also failed.

TextBox1.Value = test_mr.miss_rn.List(.ListIndex, 1)

I am getting an "Object required." error.

 

[Ark68]

Maybe send the desired value from userform2 to a cell in the workbook that has userform1 and then have the textbox in userform1 reference that cell in its own workbook. Would be a lot easier then trying to reference a control I would imagine.

Note this has been cross-posted here

Yes ... I mentioned that in my original post.

 

[Ark68]

Note RoryA and myself also spent a fair bit of time on this issue at this MrExcel thread as well.

Yes you did and for that I am thankful. I've asked so many questions with this large endeavour I forgot how similar some questions are.