| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Multiple User Forms to pass info from one to the other
Dear Experts,
I have set up one userform and when one of the buttons is clicked, a second userform is shown. How can I have information input by the user in the second userform that can be transferred to the first userform? Thanks in advance. Neal |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using Multiple User Forms to pass info from one to the other
Hi Neal
There are many ways to do that. Here is one of them. Userform2 code: Option Explicit Public MyMessage As String Private Sub UserForm_Activate() Me.Caption = MyMessage End Sub Userform1 button code: Private Sub CommandButton1_Click() UserForm2.MyMessage = "Yo!" Unload Me UserForm2.Show End Sub HTH. Best wishes Harald "Neal" skrev i melding ... Dear Experts, I have set up one userform and when one of the buttons is clicked, a second userform is shown. How can I have information input by the user in the second userform that can be transferred to the first userform? Thanks in advance. Neal |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using Multiple User Forms to pass info from one to the other
Dear Harald,
Thanks for your help. This is exactly what I need. "Harald Staff" wrote: Hi Neal There are many ways to do that. Here is one of them. Userform2 code: Option Explicit Public MyMessage As String Private Sub UserForm_Activate() Me.Caption = MyMessage End Sub Userform1 button code: Private Sub CommandButton1_Click() UserForm2.MyMessage = "Yo!" Unload Me UserForm2.Show End Sub HTH. Best wishes Harald "Neal" skrev i melding ... Dear Experts, I have set up one userform and when one of the buttons is clicked, a second userform is shown. How can I have information input by the user in the second userform that can be transferred to the first userform? Thanks in advance. Neal |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to use same text box info on numerous other forms | Excel Discussion (Misc queries) | |||
| Forms - pick up info from one worksheet to another | Excel Discussion (Misc queries) | |||
| User/pass prompting code | Excel Programming | |||
| Multiple User Forms | Excel Programming | |||
| Using multiple user forms to perform Calculations | Excel Programming | |||
Linear Mode
