MultiPage or Tab Strip

WorkMC

Board Regular
Joined
Jul 21, 2005
Messages
88
I'm in the process of setting up a userform and was wondering which is the best option to use Multipage or Tab strip. Having never used either before I can't figure out the difference?
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

DominicB

Well-known Member
Joined
Oct 3, 2005
Messages
1,569
Good morning WorkMC

The main difference between a tabstrip and a multiform is that the tabstrip does not act as a "container" for other controls. You'll find the multiform much easier to use with a syntax such as:

If MultiPage1.Value = 0 Then...

to detect if tab 1 is active.

In general I think you'll find multiform easier and more versatile.

HTH

DominicB
 

Watch MrExcel Video

Forum statistics

Threads
1,118,817
Messages
5,574,497
Members
412,598
Latest member
Haven1234
Top