View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default 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?