Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy from text box
I want to use a macro to copy data from a text box to a cell.
To copy the contents of TextBox10 on sheet "Customer Info" to cell B43 on sheet "Answers" I have tried recording a macro whilst highlighting the text and then manually copying it, but that doesn't work. I have also tried the code : Sheets("Answers").Select Range("B43").Value=Worksheets("Customer Info).TextBox10.Text which I found in another thread on this board. but I get a run-time error '438' : object doesn't support this property or method (on the second line of this.) Anyone got any ideas??? Thanks Phil |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
text box insert in Excel - text box lines print on second copy | Excel Discussion (Misc queries) | |||
Copy text from Ms Access record to Excel text box | Excel Programming | |||
I want to link, not just copy,Word source text to a text box in Ex | Excel Worksheet Functions | |||
Search for text, copy the number in front of text | Excel Programming | |||
open some txt files ,find text , copy the text before that to a single cell | Excel Programming |