P PhilM Jun 14, 2006 #1 How do I pass a value obtain via a userform to another userform which initially called the 1st userform?
How do I pass a value obtain via a userform to another userform which initially called the 1st userform?
B Bob Phillips Jun 14, 2006 #3 You could set a property in the second userform , and set that before opening Userform2.myVar = "Test" Userform2.Show and then in Userform2 Public myVar Private Sub UserForm_Activate() MsgBox myVar End Sub -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
You could set a property in the second userform , and set that before opening Userform2.myVar = "Test" Userform2.Show and then in Userform2 Public myVar Private Sub UserForm_Activate() MsgBox myVar End Sub -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
