Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing arguments to userforms | Excel Programming | |||
Data Validation on UserForms | Excel Programming | |||
Passing variable values from userforms | Excel Programming | |||
Userforms and Data | Excel Programming | |||
UserForms and Variables and Types of data | Excel Programming |