Only getting first 256 characters of text box
 

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

--
Message posted from http://www.ExcelForum.com