![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
MrExcel MVP
Join Date: Jun 2002
Location: Omaha, Nebraska
Posts: 3,895
|
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 ] |
|
|
|
|
|
#2 |
|
MrExcel MVP
Join Date: May 2002
Posts: 8,963
|
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 |
|
|
|
|
|
#3 |
|
MrExcel MVP
Join Date: Jun 2002
Location: Omaha, Nebraska
Posts: 3,895
|
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! ***************** |
|
|
|
|
|
#4 |
|
MrExcel MVP
Join Date: May 2002
Posts: 8,963
|
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 |
|
|
|
|
|
#5 |
|
MrExcel MVP
Join Date: Jun 2002
Location: Omaha, Nebraska
Posts: 3,895
|
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! ***************** |
|
|
|
|
|
#6 | ||
|
MrExcel MVP
Join Date: Feb 2002
Location: Auckland, New Zealand
Posts: 4,208
|
Quote:
your earlier Q was Quote:
|
||
|
|
|
|
|
#7 |
|
Join Date: Jul 2002
Posts: 72
|
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 ] |
|
|
|
|
|
#8 |
|
MrExcel MVP
Join Date: Jun 2002
Location: Omaha, Nebraska
Posts: 3,895
|
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! ***************** |
|
|
|
|
|
#9 |
|
MrExcel MVP
Join Date: May 2002
Posts: 8,963
|
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.
_________________ Regards, Tushar www.tushar-mehta.com [ This Message was edited by: tusharm on 2002-08-08 05:43 ] |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|