Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Textbox Control Source
I am trying to change the control source of a textbox...i have tried the following code, without any luck: txtOperations.ControlSource = Sheets("Severity Data").Range("G6") The contents of G6 is very long ( ~200-500 characters), should I maybe store the string of text in a file instead of a cell, then copy it to the text box. If anyone has any suggestions, it would be greatly appreciated!!! Regards, Dustin -- tess457 ------------------------------------------------------------------------ tess457's Profile: http://www.excelforum.com/member.php...o&userid=13938 View this thread: http://www.excelforum.com/showthread...hreadid=345548 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Textbox Control Source
Perhaps you could use the "LinkedCell" property to display the text in G6 in
your textbox: e.g. txtOperations.LinkedCell = "'Severity Data'!G6" -Stan Shoemaker Palo Alto, CA "tess457" wrote: I am trying to change the control source of a textbox...i have tried the following code, without any luck: txtOperations.ControlSource = Sheets("Severity Data").Range("G6") The contents of G6 is very long ( ~200-500 characters), should I maybe store the string of text in a file instead of a cell, then copy it to the text box. If anyone has any suggestions, it would be greatly appreciated!!! Regards, Dustin -- tess457 ------------------------------------------------------------------------ tess457's Profile: http://www.excelforum.com/member.php...o&userid=13938 View this thread: http://www.excelforum.com/showthread...hreadid=345548 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Syntax for control source in combo box control | Excel Discussion (Misc queries) | |||
How to move cursor from one textbox control to another textbox con | Excel Programming | |||
How to move cursor from one textbox control to another textbox con | Excel Programming | |||
Set Focus Problem for textbox control on multipage control | Excel Programming | |||
Query on Control Source in Userform Textbox | Excel Programming |