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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Newbie Help - IF Yes No Function 0
Drop down list control value in vba 2
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Replacing a phrase with carriage returns 1
Create form with checkbox les that expand and collapse sections of the form? 0
Use TODAY() function as the criteria in a SUMIF formula 1
Crating User Form to Add Names 1
Copy and Paste Word 2010 0

Top