TabStrip vs. MultiPage

phantom1975

MrExcel MVP
Joined
Jun 3, 2002
Messages
3,962
What is the difference? They seem to be exactly the same and the help files don't really elaborate too much about them. Is one better than the other? Is there a way to change the back color? The only thing I can think of is to create a bitmap the color that I want and insert it as a picture.

_________________
magicbus.gif

Still riding the little school bus that says VBA code on the side....
This message was edited by phantom1975 on 2002-08-07 16:38
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
I typed in 'tabstrip' (w/o the quotes) and the very first topic I got was 'Should I use a MultiPage or a TabStrip?' Another topic was 'What is a TabStrip?'

Searching for multipage resulted in the topic 'What is a MultiPage?'

There are also pages 'MultiPage Control' and 'TabStrip Control.'

These give a very comprehensive picture of what each of these two (Tabstrip and Multipage) do. Check out the pages (and don't forget the 'See also' links). If you still have questions please specify what part of all those pages you did not understand.
 
Upvote 0
Although the help files may make PERFECT sense to you, I am afraid I have no idea what they are talking about. Will someone please offer an example of when you would use one over the other.
 
Upvote 0
OK.

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. One page might contain personal information such as name and address; another page might list previous employers; a third page might list references.

The MultiPage lets you visually combine related information, while keeping the entire record readily accessible.

On the other hand...

You can use a TabStrip to view different sets of 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.

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.

Does that help?
 
Upvote 0
That is exactly the same information that I read in the help file. Based on either situation, it sounds like you can use a MultiPage OR a TabStrip and accomplish the same thing.
 
Upvote 0
On 2002-08-07 18:20, phantom1975 wrote:
That is exactly the same information that I read in the help file. Based on either situation, it sounds like you can use a MultiPage OR a TabStrip and accomplish the same thing.

NO, Not for what you want!
your earlier Q was
SNIP...Is there a way to change the back color? The only thing I can think of is to create a bitmap the color that I want and insert it as a picture.

So based on your Q, you would use a Multipage control....you have asked and answered your qustion.
 
Upvote 0
If a small business has four branches in a town, you can use a tab strip with four tabs. Clicking on each tab will display information about a corresponding branch using a common set of controls like text boxes, image boxes etc. When you click on a new tab, only the contents of the controls will change, not their type, layout etc.

On the other hand, a multipage will have tabs correspoding to sales summary, product range, employees etc. Obviously the format and entire appearance of the products page will be completely different from the employees one. So each tab will refer you to a completely different set of controls, collectively called a 'page'.

Good Luck
This message was edited by jemand on 2002-08-07 23:19
 
Upvote 0
So if I understand this correctly, when you use a TabStrip the controls (objects) are constant throughout all the tabs. A MultiPage allow different controls on each page.

If this is the case, it sounds like a tabstrip is pretty much like a ComboBox control. You can cycle through the tabs in the same way you can cycle through a ComboBox to change all the other controls (objects) on a UserForm.

Do I have the right idea?
 
Upvote 0
Thanks for your PM. I'll be happy to let others act as interpreters of the help files.

Though, I cannot help but wonder how you choose to learn about a new subject. Before my first response on this topic, I reread the help files and created userforms with both a tabstrip and a multipage control. After running the userforms, the contents of help files were obviously correct.

Have you created the controls? Used them?

But, I agree with you on one subject. My skills are not suited to helping you. I wish you all the success you persistence deserves.<pre style="color:#800000">
Posted: 2002-08-07 16:48
--------------------------------------------------------------------------------
I appreciate you letting me know that help files exist, Tusharm,
but I am afraid that they aren't very clear.
I will ask that if you have no intention of adding any information,
please don't bother posting to my topics.</pre>

_________________
Regards,

Tushar
www.tushar-mehta.com
This message was edited by tusharm on 2002-08-08 05:43
 
Upvote 0
What is the difference? They seem to be exactly the same and the help files don't really elaborate too much about them. Is one better than the other? Is there a way to change the back color? The only thing I can think of is to create a bitmap the color that I want and insert it as a picture.

_________________
magicbus.gif

Still riding the little school bus that says VBA code on the side....

[SIZE=-1][ This Message was edited by: phantom1975 on 2002-08-07 16:38 ][/SIZE]

Both can hold a lot of information, and behave the same, BUT:

* A TabStrip can't hold other TabStrips or Multipages inside.
* A Multipage can hold either TabStrips or Multipages inside.

So, a Multipage allows you to handle more complex information pages.

Clear?
 
Upvote 0

Forum statistics

Threads
1,223,911
Messages
6,175,333
Members
452,636
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top