All,
I have an interesting problem. I am retrieving external data from a SQL server. In a cell (A2 we'll say) there is text of more than 3000 characters. It is a synopsis of the report data. I need to copy all of the text in cell A2 to a textbox that resides on another sheet. I have tried the solutions at support.microsoft.com and it works (from a cell to a textbox) but not for more than 255 characters. Does anybody have any ideas? I am at desperate times. Thanks in advance for your help.
I have an interesting problem. I am retrieving external data from a SQL server. In a cell (A2 we'll say) there is text of more than 3000 characters. It is a synopsis of the report data. I need to copy all of the text in cell A2 to a textbox that resides on another sheet. I have tried the solutions at support.microsoft.com and it works (from a cell to a textbox) but not for more than 255 characters. Does anybody have any ideas? I am at desperate times. Thanks in advance for your help.