View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tess457[_7_] tess457[_7_] is offline
external usenet poster
 
Posts: 1
Default 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