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
|