One way is to set the control source property to the cell

Sheet1!A1

Another way is to run code that writes the value

Private Sub Cmd_OK_Click()
Worksheets("Sheet1").Range("A1").Value = Textbox1.Text
unload me
End Sub

--
Regards,
Tom Ogilvy



Betsy wrote in message
...
How do I pass the values entered in a text box on a user
form to a cell in the spreadsheet?

Thanks.

Betsy