XL98: Toolbox Disappears After Clicking TabStrip Control Tab

Last reviewed: March 2, 1998
Article ID: Q181908
The information in this article applies to:
  • Microsoft Excel 98 Macintosh Edition

SYMPTOMS

When you add a TabStrip control to a UserForm, and then click a tab on the TabStrip, the Toolbox disappears.

CAUSE

A Tabstrip is not a separate form, but is a control on a UserForm that contains Tab objects. Because the border of the TabStrip defines a region of the form that you can associate with the tabs, when you place a control in the client region of the TabStrip, you are simply adding another control to the form that contains the TabStrip. Therefore, because a Tab cannot contain a control, the Toolbox is not displayed when a Tab is selected.

WORKAROUND

If you want the toolbox to reappear, click the UserForm that contains the TabStrip. This places the focus on the UserForm, and the toolbox is available for adding more controls to the UserForm.

STATUS

This behavior is by design of TabStrips in Microsoft Excel 98.

MORE INFORMATION

A UserForm TabStrip control is very similar to a MultiPage control. But, the two controls are used in different implementations of your UserForm.

A MultiPage is useful when you work with a large amount of information that can be sorted into several categories. For example, use a MultiPage to display information from an employment application, where one page might contain personal information, such as name and address, and another page might contain personal references.

A TabStrip is used to view different sets of related information for related controls. For example, the controls might represent information about a daily schedule for a group of individuals, with each set of information corresponding to a different individual in the group. You could then set the title of each tab to show one individual's name. Then, you can write code that, when you click a tab, updates the controls to show information about the person identified on the tab.

REFERENCES

For more information about the Tabstrip control, click the Office Assistant while in the Visual Basic Editor, and type "What is a Tabstrip Control?" click Search, and then click to view "TabStrip Control"

NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar.


Additional query words: tab strip XL98
Keywords : xlvbainfo kbdta
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbprb
Solution Type : kbnofix


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 2, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.