BackColor in Excel VBA Multipage for individual pages

Posted on 2011-05-06
Last Modified: 2012-05-11
Has anybody found a way to set the backcolor on individual pages of a multipage control in Excel VBA?
Question by:NormanMitchell
    LVL 22

    Accepted Solution

    If you select the Multipage object, you can set the area behind the tabs, but I suspect that's not what you want.

    Since the pages themselves don't support a background color, a trick is to add a label that has no text and spans the entire region of the page, then put whatever background color you want.

    When you eventually get to VB.Net, the tab/page controls indirectly support that feature.
    LVL 5

    Assisted Solution


    you can work around this problem as follows:
    1/ Place a frame on your form in which you place the multipage control.
    2/ Set the top and left values of the multipage outside the frame (e.g. -5).
    3/ Ajust the height and width of the multipage so that its edges are no longer visible.
    4/ Now you can place a frame on every page of the multipage control and give it the desired background color.
    5/ You can control the multipage control by setting its value from your code.


    you can resolve the situation by fill the multipage control with a .jpg file with a cool background... but will not use the buttons you can control also from the code.

    Good luck,

    Author Closing Comment

    Again great work by the team of experts!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Sometimes we don't want to show zeros in our Excel spreadsheets. This is sometimes most evident in our charts. Look at the chart below, all the zero values are visible. I think that all will agree with the fact that zero values are not looking nice …
    What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now