Well, that's good to know, then. I don't think I can break it up enough to
get down to 100/form, but I think just seperating the tabs into their own
userform may eliminate a whole bunch of headaches.

Thanks for that, Jon. :)

"Jon Peltier" wrote:

I've heard anecdotal evidence of an apparent behavioral limit of "about 250"
controls per userform. This is similar to VB's hard 256 limit on control
names, but probably unrelated. I had problems with one userform with around
350, but a redesign brought it under 100 and everyone was happy.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"NickHK" wrote in message
...
Whilst VB6 forms have a limit of 255 (256 ?) names of controls, this works
fine in VBA/Forms2:

Private Sub CommandButton1_Click()
Dim i As Long
Dim Lab As msforms.Label

For i = 1 To 5000
With Me.Controls
Set Lab = .Add("Forms.Label.1", "Label" & i)
Lab.Caption = "Number " & i
End With
Next

End Sub

So I doubt the OP problem is directly caused by too many controls,
although
I doubt 1200 controls would make a manageable UI.

NickHK

"Jim Rodgers" wrote in message
...

It sure is tricky to make control arrays in VBA, especially since VBA
does
not support control arrays.

I would suggest studying a decent VBA resource.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


I was just trying to be helpful.

I do not write much in VBA, but you must admit it is in most ways
identical
to VB6. I've written about a half a million lines of that stuff. More
than
I can remember sometimes. Coding VB is not my main profession anymore.

"I would suggest studying a decent VBA resource."

Decent? Hmmmph. Your remarks were perceived as unfriendly, S.A. I bet
you
think you wrote a decent VBA resource, eh? (By the way, you CAN go broke
underestimating the intelligence of your fellow man.)