Userform to userform

[Rkeev]

Hello Excel masters,

I am trying to populate (via VBA) a textbox/combo box from one user form to another user form.
The first user form has a room number in a text box1. If certain conditions exists, a button is selected to bring up another user form (both forms are modeless).
I want to pass/populate some of the 1st user Form info into the other user form.

I have tried the on initialize textbox1.value = textbox other.value but no dice. I can populate a user form text box from a spreadsheet but from box to box in separate user forms has me a little stumped.

Any help would be appreciated.

thx,
Rkeev

 

[Gavin T]

On initialize enter the following code:

Private Sub UserForm_Initialize()

Me.TextBox1.Value = UserForm1.TextBox1.Value

End Sub

 

[Rkeev]

Solved--- Thanks Gavin, I was forgetting to place the user form name into code. Plus I was also going from a list box to a Txt box in anther part of the form so I had to identify the index, but thank vey much for the assistance.

thx,
RKeev

 

[Gavin T]

Great, thanks for the feedback!