Passing Text from User Form to Spreadsheet

[Betsy]

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

Thanks.

Betsy

 

[Tom Ogilvy]

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