View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default 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