Open a user form
 

Hi,
I 've created a Userform called "Result",I need to open this form on the
event of a click event of button,i need also to that,for example the textbox
"Score" on the form equals the cell "Answer!C22" on the sheet?
Can anybody help?

Open a user form
 

Sub myButton_Click()
Userform1.Score.Text = Worksheets("Answer").Range("C22").Text
Userform1.Show
End Sub

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Pietro" wrote in message
...
Hi,
I 've created a Userform called "Result",I need to open this form on the
event of a click event of button,i need also to that,for example the
textbox
"Score" on the form equals the cell "Answer!C22" on the sheet?
Can anybody help?