B Betsy Aug 6, 2003 #1 How do I pass the values entered in a text box on a user form to a cell in the spreadsheet? Thanks. 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 Aug 6, 2003 #2 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
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
