Passing data between Userforms

C

Coza

I am having trouble passing a value from Userform4.Combobox1.value
to
Userform3.Textbox1.value

The value passes, but how do i successfully Close Off the Userform4 after
the value is input into u/f3 ?

Private Sub UserForm_Activate()
Application.ScreenUpdating = False
Userform3.TextBox1.Value = UserForm4.ComboBox1.Value
'Code to populate Userform3 here
Application.ScreenUpdating = True
End Sub


Corey....
 
J

JLGWhiz

What do you mean by "close off"? You can use UserForm4.Hide to make it
invisible or you can use Unload UserForm4 to deactivate it altogether until
you want it to Show again. The Unload method releases the memory where the
form is stored.
 

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

Top