View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
IT_roofer IT_roofer is offline
external usenet poster
 
Posts: 45
Default Number of UserForm Control Objects

For the sake of arguement, I'm not generating any objects dynamically or with
an array. I have never been good with arrays so I stay away from them. :)

"Peter T" wrote:

I have no doubt you were trying to be helpful but, in the nicest possible
way, with the exception of your implied suggestion to the OP to follow up
Chip's advice, your previous suggestions were misleading at best or
incorrect.

I do not write much in VBA, but you must admit it is in most ways

identical
to VB6.


VB6 forms and VBA forms are radically different. As Jon said, control-arrays
are not supported in VBA, but that's only one of so many differences.

Your [Jon's] remarks were perceived as unfriendly,


I can't speak for Jon but I didn't interpret his remarks that way at all,
simply as being helpful; both to yourself and to others.

Regards,
Peter T


In VB6 the number of controls is limited to 254 (excl additional controls in
control-arrays). In VBA
"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.)