Too many different formats and Userforms

[RJQMAN]

I hit the wall with too many formats, and I understand from other
posts how to fix the problem in general. However I am not certain if
Userforms somehow go into the count when counting the 4,000 different
formats. Are they totally independent or should I be trying to
minimize the different formats in my Userforms too? I have about 20
Userforms at this time. Thanks in advance.

 

[Peter T]

Qty of unique cell formats and qty userforms are not related, at least not
directly.

It sounds like you know how to deal with the "too many cell formats" issue.
20 Userforms in a well designed project should not be a problem at all.

Regards,
Peter T

 

[RJQMAN]

Qty of unique cell formats and qty userforms are not related, at least not
directly.

It sounds like you know how to deal with the "too many cell formats" issue.
20 Userforms in a well designed project should not be a problem at all.

Regards,
Peter T






- Show quoted text -

Thanks for responding, but my fundamental question remains - do
Userforms enter into the count of the 4,000 maximum different
formats? If so, I should probably be trying to limit the format
variations on my userforms too... I am going to run close to the
maximum. I have to redesign a bit now, as I have hit the wall and
need to go back and clean everything up a bit to get out of trouble on
this 4,000 format question. I had been using formats without even
thinking about there being a maximum, and no doubt I can eliminate a
ton of them if I set out from scratch to do so, but it would be
helpful for me to know the answer to the Userform question. Thanks...

 

[Peter T]

my fundamental question remains -

do Userforms enter into the count of the 4,000
maximum different formats?

No. As I said before qty of unique cell formats and userforms are not
directly related.

FWIW that 4000 figure is very arbitrary, can hit the "too many cell formats"
limit with even say 3000.

Regards,
Peter T

Qty of unique cell formats and qty userforms are not related, at least not
directly.

It sounds like you know how to deal with the "too many cell formats"
issue.
20 Userforms in a well designed project should not be a problem at all.

Regards,
Peter T






- Show quoted text -

Thanks for responding, but my fundamental question remains - do
Userforms enter into the count of the 4,000 maximum different
formats? If so, I should probably be trying to limit the format
variations on my userforms too... I am going to run close to the
maximum. I have to redesign a bit now, as I have hit the wall and
need to go back and clean everything up a bit to get out of trouble on
this 4,000 format question. I had been using formats without even
thinking about there being a maximum, and no doubt I can eliminate a
ton of them if I set out from scratch to do so, but it would be
helpful for me to know the answer to the Userform question. Thanks...

 

[RJQMAN]

No. As I said before qty of unique cell formats and userforms are not
directly related.

FWIW that 4000 figure is very arbitrary, can hit the "too many cell formats"
limit with even say 3000.

Regards,
Peter T








Thanks for responding, but my fundamental question remains - do
Userforms enter into the count of the 4,000 maximum different
formats?  If so, I should probably be trying to limit the format
variations on my userforms too...  I am going to run close to the
maximum.  I have to redesign a bit now, as I have hit the wall and
need to go back and clean everything up a bit to get out of trouble on
this 4,000 format question.  I had been using formats without even
thinking about there being a maximum, and no doubt I can eliminate a
ton of them if I set out from scratch to do so, but it would be
helpful for me to know the answer to the Userform question. Thanks...- Hide quoted text -

- Show quoted text -

Thanks for the explanation. I appreciate it. It is 14 below zero
farenheit here, and my brain is still fried. Have a great day.