Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Textbox limitations
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! : ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Textbox limitations
I am sure there is a size limit in a textbox, but I believe it is up around
32K characters. -- Regards, Tom Ogilvy "Elaine" wrote in message ... Hi, I have been writing a program that imports a file of text into a textbox. My program goes through this text and finds certain data to be displayed on the specified worksheet. My problem is that, when it hits a certain point, my cursor goes back to the beginning and does not continue to search. When I look at the textbox, the data is there. For some reason, my program doesn't continue searching. Is there a size limit to the text box? Some guidance will be appreciated. Thanks! :) ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Textbox limitations
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 ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Textbox limitations
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. -- Regards, Tom Ogilvy "Elaine" wrote in message ... Is there any way I can enlarge it? If I hit the limit, shouldn't the text be truncated? Currently, my textbox displays all of the data I need, but only processes part of it. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Textbox limitations
Thanks so much for your help. I'll try to figure it out. It's going very slowly though :( ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel limitations | Excel Discussion (Misc queries) | |||
row limitations on excel | Excel Discussion (Misc queries) | |||
Excel Limitations | Excel Discussion (Misc queries) | |||
Excel Limitations?? | Excel Discussion (Misc queries) | |||
Textbox limitations? | Excel Programming |