Passing values

  • Thread starter Thread starter PhilM
  • Start date Start date
P

PhilM

How do I pass a value obtain via a userform to another userform which
initially called the 1st userform?
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Userform textbox string to header causes unwanted double spacing 4
pass value to excel userform - is there a constructor? how to pass 6
Is there a way to test if a control exists on a userform? 4
userforms 5
User form varible passing 4
passing data 2
Open Userform two ways 3
Capture/Passing Commandbutton click 5

Back
Top