Return value from another form

D

DMc2007

Hi

how can i using VBa return a value from another form. The form will be
hidden.

Regards

D
 
H

Helmut Weber

Hi,

Sub Macro8()
UserForm1.Show
UserForm2.Show ' userform2 is hidden
End Sub

' in userform1
Private Sub CommandButton1_Click()
MsgBox UserForm2.TextBox1.Text
End Sub

--

Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Vista Small Business, Office XP
 
Top