Textbox Control Source

  • Thread starter Thread starter tess457
  • Start date Start date
T

tess457

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA Error 400 1
Advice on multiple macros, same code just a different column 9
UserForm - pointing control source to new sheet - long delay 5
userform exception error 4 textboxes 7
Code in 2003 not working in 2007 9
Time format in userform textbox 4
copy text from textbox to another application 3
Control in Excel 2007 2

Back
Top