Can a userform multipage backcolor be changed?

DRJ

DRJ

MrExcel MVP
Joined
Feb 17, 2002
Messages
3,853
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??
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
Sort by date Sort by votes
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".
 
Upvote 0
Tom Urtis said:
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".
Click to expand...

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.
 
Upvote 0
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.
 
Upvote 0
Not ideal, but a very creative solution Tom. Thanks for the suggestion! It works great for what I wanted to do.
 
Upvote 0
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.
 
Upvote 0
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 ?
 
Upvote 0
huyen891977 said:
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 ?
Click to expand...

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 )
 
Upvote 0
You must log in or register to reply here.

Similar threads

P
  • Question Question
RUNTIME ERROR 91 for USERFORM CODE
Replies
1
Views
90
6StringJazzer
6StringJazzer
H
  • Question Question
Userform Help
Replies
5
Views
341
Hjemmet
H
T
  • Question Question
Refer to a sheet selected by combobox
Replies
2
Views
378
dmt32
D
P
  • Solved
Userform - Only allow one OptionButton to be selected inside multipage within a Frame with other OptionButtons
Replies
7
Views
1K
PioSwgr
P
P
  • Question Question
Command Buttons on Userform
Replies
5
Views
505
PaulWJ
P

Forum statistics

Threads
1,223,933
Messages
6,175,473
Members
452,646
Latest member
tudou

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top