ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Textbox limitations? (https://www.excelbanter.com/excel-programming/274273-re-textbox-limitations.html)

keepITcool

Textbox limitations?
 
Chuck...

Why the h*ll do you use so many textboxes?
Dont tell me you've got different code for every box :(

you just may be at the limit of what forms can handle or vba can
compile.


Have you subclassed them ?
That avoids a LOT of repetitive coding.

Can you email me what you've got and can I have a look
to see if there's an alternative?

address below... i'll be here for another 2 hours or so.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Chuck B" wrote:

I'm writing a pretty sophisticated userform in excel 97
VBA. I have added textbox239. When I try to add
textbox240 and attach code to it I get this message:


"Excel.exe had generated errors and will be closed by
Windows. You will need to restart the program."

an error log has been generated.

Is there some sort of limit on how many textboxes you are
allowed in one userform?

Any help would be welcomed.

thanks





All times are GMT +1. The time now is 11:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com