| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get values from Controls in Excel-sheet
Hi!
I have a textbox from the Controls in my spreadsheet. How can I get/copy the value from this textbox to a cell in my spreadsheet? BR Trond |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get values from Controls in Excel-sheet
worksheets("Sheet1").Range("A1").Value = _
Userform1.Textbox1.Value -- Regards, Tom Ogilvy "Trond Fugleberg" wrote in message ... Hi! I have a textbox from the Controls in my spreadsheet. How can I get/copy the value from this textbox to a cell in my spreadsheet? BR Trond |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Get values from Controls in Excel-sheet
The textbox is in the worksheet not in a userform! Else
your solution would have been perfect! Regards Trond -----Original Message----- worksheets("Sheet1").Range("A1").Value = _ Userform1.Textbox1.Value -- Regards, Tom Ogilvy "Trond Fugleberg" wrote in message ... Hi! I have a textbox from the Controls in my spreadsheet. How can I get/copy the value from this textbox to a cell in my spreadsheet? BR Trond . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I split form controls in a sheet in excel? | Excel Discussion (Misc queries) | |||
| how to activate controls in protected sheet | Excel Worksheet Functions | |||
| Need more than 1208 controls per sheet | Excel Discussion (Misc queries) | |||
| Counting Controls in a sheet | Excel Programming | |||
| Accessing the values of form controls on worksheets in Excel 2000 | Excel Programming | |||
Linear Mode
