| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform Textbox writing to a cell
I am having trouble with using a textbox inside of a
userform and having the value entered into the textbox transferred to a specific excel cell. I'm am new at this programming, and purchased a great book on VBA in Excel. However, the book seems to just skip this detail. Any help would be appreciated, thanks. Rich |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Userform Textbox writing to a cell
Rich,
Worksheets("Sheet1").Range("A1").Value = TextBox1.Value The above (when run) will copy whatever is in TextBox1 to Sheet1, Cell A1 (modify to suit your needs). Post back if you need more help with this. John Rich wrote: I am having trouble with using a textbox inside of a userform and having the value entered into the textbox transferred to a specific excel cell. I'm am new at this programming, and purchased a great book on VBA in Excel. However, the book seems to just skip this detail. Any help would be appreciated, thanks. Rich |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Userform with textbox displaying Cell B1 Value | Excel Discussion (Misc queries) | |||
| Add COUNTIF TO USERFORM TEXTBOX | Excel Worksheet Functions | |||
| writing data to a textbox in a chart | Excel Discussion (Misc queries) | |||
| userform textbox | Excel Worksheet Functions | |||
| Populating Textbox in UserForm | Excel Programming | |||
![Rich[_12_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
