Multipage UserForm

[Patrick C. Simonds]

I have discovered the MultiPage UserForm and am trying out combining my 8
primary UserForms onto one MultiPage UserForm. I am wondering of there is
any way in which to set a different color for each Page?




---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 000756-0, 07/12/2007
Tested on: 7/11/2007 8:12:53 PM
avast! - copyright (c) 1988-2007 ALWIL Software.
http://www.avast.com

 

[Russ]

You can add a picture as a backdrop or experiment with frames and their
background color. Use the object window to change their properties.
With Frames, you might have to use the layers menu to put it behind other
objects. Sometimes objects get 'lost' when layering and you use the object
window to select them even when unseen and the layer menu to bring them back
on top of other objects.

 

[Jonathan West]

I have discovered the MultiPage UserForm and am trying out combining my 8
primary UserForms onto one MultiPage UserForm. I am wondering of there is
any way in which to set a different color for each Page?

Before you proceed with this, just count up the number of controls on your
existing 8 forms. If combining them onto a single form is likely to push the
total number of controls beyond 400, then you are better off keeping them
separate. There is a limit of about 410 controls on a form. Any more than
that an it won't work and you will get crashes.

 

[Tony Strazzeri]

Additionally, If all of your tabpages contain the same controls then
you should look at using the TabPage control instead of the MultiPage
control. Essentially the Tabpage is list of tabs provides a set of
headings for the same layout of data. The data for each "set" is
stored in memory in an array instead of individual controls.

This will certainly reduce the number of objects (controls or
userforms) you need to deal with.

Hope this helps.

Cheers
TonyS.