Only getting first 256 characters of text box

W

will_w

Hello, I'm having trouble with textboxes!

Here's basically what I have:

Public sub get_text()
dim myString as String

myString = Worksheets(1).Texboxes(1).Text

[...]

End Sub

The problem is, myString only seems to grab the first 256 characters o
the text box. I'm sending the text to another application, so th
character limit of excel cells shouldn't be an issue.

Any ideas?:confused:

Wil
 
Top