You won't believe this, KeepItCool. I actually removed quite a few lines
already by creating a Class routine that handled the textbox's data input
functions.

But there's so much processing going on in the userform- that's why there's
so much code. I agree with you, it's stretching VBA to the limits.

PS. It's not my code!! LoL I'm the one left to FIX it.....CYA

--


Julian Milano

"keepitcool" wrote in message
...
Julian...

The number of controls wont/shouldnt be the bottleneck
(increase userform.drawbuffer should solve that..)

but 4.4K lines of code that's stretching vba/excel

how the h*ll did you do that?
ever heard of subclassing?


keepITcool

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


"Julian Milano" wrote:

Thanks Tom,

It looks to me like there are too many controlls on this userform. It
contains a 14 page multipage controls, where each page prob has about
30 labels, 30 textboxes/combos. Then you've got the 4389 lines of VBA
code in the userform!!

I think I'll have to split the userform up into three parts to fix
this problem.