Excel Textbox limitations

[Elaine]

Hi,
I have been writing a program that imports a file of text into
textbox. My program goes through this text and finds certain data t
be displayed on the specified worksheet. My problem is that, when i
hits a certain point, my cursor goes back to the beginning and does no
continue to search. When I look at the textbox, the data is there.
For some reason, my program doesn't continue searching. Is there
size limit to the text box?
Some guidance will be appreciated. Thanks! :

 

[Tom Ogilvy]

I am sure there is a size limit in a textbox, but I believe it is up around
32K characters.

 

[Elaine]

Is there any way I can enlarge it? If I hit the limit, shouldn't th
text be truncated? Currently, my textbox displays all of the data
need, but only processes part of it

 

[Tom Ogilvy]

I experimented with a textbox from the drawing toolbar and I could put 32000
characters in it, but I could only edit up to about 29000. When I deleted
some characters from the beginning, then I could see the remainder of the
characrters where actually there.

This sounds a little different from what you are seeing, so I can't explain
that.

 

[Elaine]

Thanks so much for your help. I'll try to figure it out. It's going
very slowly though