"red6000" <red1000002001[ at ]yahoo.com> wrote in message
news:448870b2$0$3539$ed2619ec[ at ]ptn-nntp-reader01.plus.net...
[Quoted Text] > 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
|