XL98: Toolbox Disappears After Clicking TabStrip Control Tab (181908)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q181908 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.
| Modification Type: | Major | Last Reviewed: | 9/11/2002 |
|---|
| Keywords: | kbprb KB181908 |
|---|
|