red6000 said:
Can anyone explain what the purpose of the tabstrip tool is in userforms
and why you would ever use it over the multipage tool?
In most cases, I would use a multipage in preference to a tabstrip, and
place controls as required on each page.
However, for large and complex userforms there is a potential problem with
this - userforms have a hard limit of about 450 controls. If you add any
more, then the form crashes. Therefore, under this circumstance, if
everything had to be on one form, I would consider showing and hiding
individual controls depending on which tab of the tabstrip was selected, and
also change the captions of checkboxes & optionbuttons, to give the
appearance of being different controls.
Such a form would be fiddly to code & debug, but it would be a way round the
450 controls limit.
--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition
www.classicvb.org
