Lots of controls on userforms

[Kyle123]

I'm not really sure where to put this, forum wise, so I'll stick it here. I was just reading this thread http://www.excelforum.com/excel-prog...een-saved.html whete excel crashes when referencing a huge amount of controls on a page (I didn't know about the issue, but I don't find it particularly surprising), what I do find surprising is that the author alludes to this being a common problem amongst users, and there are follow up comments which appear to support this.

My question is why is this such a common problem? I can't actually ever foresee a need for 500!!! controls adding to a form at design time - it must be soul destroying to support and create. Does anyone actually have a real life example where this has been the only solution to a problem?

[Norie]

I've never experienced a problem with the no of controls, then again I've never have, and hope I never will, have 500+ controls on a userform.

Perhaps the common thing is that people aren't designing their userforms too well.

[Kyle123]

hehe me too, I can see the requirement for a lotof controls (an example being the fancy list box I cobbled together someone here a while ago), but I'd never try and do it all at design time.

I suspect you're right Norie, that the userforms could do with a re-design and anyone with this problem might find it worthwhile investing a little time in learning event handling classes.

[JosephP]

but the author provides no evidence for his statement and there are only 3 follow up comments-I would be surprised if this were a common problem in any sense in which I might use that word ;-)

[Norie]

Perhaps there might have been a problem somewhere else in the '81 worksheets, 6 userforms and 10 VBA modules'.

[Kyle123]

@josie yeah, there is that as well
@norie, yes, I thought that when I read it too, IME anyone who complains about the maximum size of a module probably needs to look at yhe structure of what they've done and go easy on the copy and paste

[Mordred]

I think that that many controls is way excessive. I agree with Norie in that the userforms are probably not being designed very well. I've (on occasion) seen here and at the code cage threads where people post problems that have userforms with 20+ controls and I even thought those were excessive. I think the most I've ever used was around 10 in one uf.

I guess a uf can get right out of control if the designer uses "Multipage" tabs and then loads them up with who knows what, making a userform so big that it's hard to maintain.

We don't use pennies in Canada anymore but that's my 2 cents.

[xladept]

I was watching the dominoes fall - a new record on you tube. Imagine that all the events in all the controls fired successively as you were trying to debug the code

[JapanDave]

I was watching the dominoes fall - a new record on you tube. Imagine that all the events in all the controls fired successively as you were trying to debug the code

WOW! I seriously was watching lions attacking hyenas on youtube and somehow ended up watching dominoes fall as well.