Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing Text from User Form to Spreadsheet
How do I pass the values entered in a text box on a user
form to a cell in the spreadsheet? Thanks. Betsy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing Text from User Form to Spreadsheet
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Embedding spreadsheet in a user form | Excel Discussion (Misc queries) | |||
Adding a new text box to user form | Excel Discussion (Misc queries) | |||
User Form: Cannot Update Text Box | Excel Discussion (Misc queries) | |||
User form and hiding spreadsheet | Excel Discussion (Misc queries) | |||
Copy one spreadsheet into another without activating second spreadsheet's user form | Excel Programming |