Passing values
 

How do I pass a value obtain via a userform to another userform which
initially called the 1st userform?

Passing values
 

use a Public variable.

hth, RicK




"PhilM" wrote in message
oups.com...
How do I pass a value obtain via a userform to another userform which
initially called the 1st userform?

Passing values
 

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)

"PhilM" wrote in message
oups.com...
How do I pass a value obtain via a userform to another userform which
initially called the 1st userform?