MrExcel Message Board


Go Back   MrExcel Message Board > Question Forums > Excel Questions

Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only.

Reply
 
Thread Tools Display Modes
Old Aug 7th, 2002, 10:23 PM   #1
phantom1975
MrExcel MVP
 
phantom1975's Avatar
 
Join Date: Jun 2002
Location: Omaha, Nebraska
Posts: 3,895
Default

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.

_________________

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 ]
phantom1975 is offline   Reply With Quote
Old Aug 7th, 2002, 10:40 PM   #2
tusharm
MrExcel MVP
 
tusharm's Avatar
 
Join Date: May 2002
Posts: 8,963
Default

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.
__________________
Tushar Mehta (Microsoft MVP Excel 2000-2009)
Excel & PowerPoint tutorials and add-ins; custom productivity solutions for MS Office
tusharm is offline   Reply With Quote
Old Aug 7th, 2002, 10:50 PM   #3
phantom1975
MrExcel MVP
 
phantom1975's Avatar
 
Join Date: Jun 2002
Location: Omaha, Nebraska
Posts: 3,895
Default

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.
__________________
Silly Billy was here....

***************** EXCEL/VB NEWBIES ARE MY FAVORITE! *****************
phantom1975 is offline   Reply With Quote
Old Aug 7th, 2002, 11:55 PM   #4
tusharm
MrExcel MVP
 
tusharm's Avatar
 
Join Date: May 2002
Posts: 8,963
Default

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?

__________________
Tushar Mehta (Microsoft MVP Excel 2000-2009)
Excel & PowerPoint tutorials and add-ins; custom productivity solutions for MS Office
tusharm is offline   Reply With Quote
Old Aug 8th, 2002, 12:20 AM   #5
phantom1975
MrExcel MVP
 
phantom1975's Avatar
 
Join Date: Jun 2002
Location: Omaha, Nebraska
Posts: 3,895
Default

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.
__________________
Silly Billy was here....

***************** EXCEL/VB NEWBIES ARE MY FAVORITE! *****************
phantom1975 is offline   Reply With Quote
Old Aug 8th, 2002, 03:21 AM   #6
Ivan F Moala
MrExcel MVP
 
Ivan F Moala's Avatar
 
Join Date: Feb 2002
Location: Auckland, New Zealand
Posts: 4,208
Default

Quote:
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
Quote:
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.

__________________
Kind Regards,
Ivan F Moala From the City of Sails
Ivan F Moala is offline   Reply With Quote
Old Aug 8th, 2002, 05:17 AM   #7
jemand
 
Join Date: Jul 2002
Posts: 72
Default

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 ]
jemand is offline   Reply With Quote
Old Aug 8th, 2002, 05:47 AM   #8
phantom1975
MrExcel MVP
 
phantom1975's Avatar
 
Join Date: Jun 2002
Location: Omaha, Nebraska
Posts: 3,895
Default

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?
__________________
Silly Billy was here....

***************** EXCEL/VB NEWBIES ARE MY FAVORITE! *****************
phantom1975 is offline   Reply With Quote
Old Aug 8th, 2002, 11:41 AM   #9
tusharm
MrExcel MVP
 
tusharm's Avatar
 
Join Date: May 2002
Posts: 8,963
Default

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.


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.


_________________
Regards,

Tushar
www.tushar-mehta.com

[ This Message was edited by: tusharm on 2002-08-08 05:43 ]
tusharm is offline   Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump


All times are GMT +1. The time now is 10:41 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
All contents Copyright 1998-2009 by MrExcel Consulting.