Open a user form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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)
 
Back
Top