Passing data between Userforms
 

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....

Passing data between Userforms
 

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.

"Coza" wrote:

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....