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

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

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