Passing Text from User Form to Spreadsheet

B

Betsy

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

Thanks.

Betsy
 
T

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
 
Top