Error Checking in Excel
Thanks Thanks:  0
Page 1 of 4 123 ... LastLast
Results 1 to 10 of 32

Thread: Can a userform multipage backcolor be changed?

  1. #1
    MrExcel MVP DRJ's Avatar
    Join Date
    Feb 2002
    Location
    California
    Posts
    3,853
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Can a userform multipage backcolor be changed?

    I have a multipage on a userform and wanted to change the back color. I can change this color fin for buttons and the userform itself, but I don't see the option in the properties for a multipage. And I didn't see it as an available command from vba. Am I missing something here??

  2. #2
    MrExcel MVP Tom Urtis's Avatar
    Join Date
    Feb 2002
    Location
    San Francisco, California USA
    Posts
    11,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Can a userform multipage backcolor be changed?

    MultiPages and TabStrips do not have background color properties and cannot themselves be colored. Complaints should be directed to Redmond, Washington...I don't understand why Microsoft has not provided for this feature but they just have not, at least not up to and including Excel2003 (its latest version to date).

    To color a multipage, here's a workaround:
    Draw an image control over the page, then set its background color to whatever you want from Image control's BackColor property palette. Right-click on the Image control, and select "Send Backward".

  3. #3
    MrExcel MVP DRJ's Avatar
    Join Date
    Feb 2002
    Location
    California
    Posts
    3,853
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Can a userform multipage backcolor be changed?

    Quote Originally Posted by Tom Urtis
    MultiPages and TabStrips do not have background color properties and cannot themselves be colored. Complaints should be directed to Redmond, Washington...I don't understand why Microsoft has not provided for this feature but they just have not, at least not up to and including Excel2003 (its latest version to date).

    To color a multipage, here's a workaround:
    Draw an image control over the page, then set its background color to whatever you want from Image control's BackColor property palette. Right-click on the Image control, and select "Send Backward".
    That's pretty lame. I figured I could stick a label on top of the multipage and color it, but then the page label tab at the top cannot be changed. So it still looks grey while everything else is colored. Oh well.

  4. #4
    MrExcel MVP Tom Urtis's Avatar
    Join Date
    Feb 2002
    Location
    San Francisco, California USA
    Posts
    11,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Can a userform multipage backcolor be changed?

    There is a Windows default setting to adjust that gray color but it's not practical if the workbook is intended for users with other computers.

  5. #5
    MrExcel MVP DRJ's Avatar
    Join Date
    Feb 2002
    Location
    California
    Posts
    3,853
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Yeah, I don't want to mess with user settings.

  6. #6
    New Member
    Join Date
    Jun 2007
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Good idea. I tried using a bitmap image but it added eight gigs to my file.

  7. #7
    Board Regular
    Join Date
    Jul 2004
    Location
    Elkhart, Indiana
    Posts
    904
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Can a userform multipage backcolor be changed?

    Not ideal, but a very creative solution Tom. Thanks for the suggestion! It works great for what I wanted to do.

  8. #8
    MrExcel MVP Tom Urtis's Avatar
    Join Date
    Feb 2002
    Location
    San Francisco, California USA
    Posts
    11,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Can a userform multipage backcolor be changed?

    Wow - - gotta love when these old threads surface, a great example of how valuable a Search can be when people get the answer on their own by researching for a question already asked and answer given. Thanks for the message Nnogslaw.

    If by chance lxplumm is looking in on this, bitmap is an uncompressed format that is about the heaviest graphic format you can use. Try a gif or jpg format (use Photoshop to save the bitmap as gif or jpg) and it will be a much-reduced graphic file size.

  9. #9
    New Member
    Join Date
    Jan 2009
    Location
    Viet Nam
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Can a userform multipage backcolor be changed?

    Hello everybody! I'm a new member. I'm a farmer and living in Vietnam. I just know a little of English. I don't know where to post my questions.
    Can you please help me ? I have a problem with my userform.
    Can I post my file here ?

  10. #10
    New Member
    Join Date
    Jan 2009
    Location
    Viet Nam
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Can a userform multipage backcolor be changed?

    Quote Originally Posted by huyen891977 View Post
    Hello everybody! I'm a new member. I'm a farmer and living in Vietnam. I just know a little of English. I don't know where to post my questions.
    Can you please help me ? I have a problem with my userform.
    Can I post my file here ?
    I design a userform to input data on worksheet but I don't know VBA code to do it. (On my userform I put many Comboboxes and many Textboxes )

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •