ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   User Forms Multipage Background/Foreground Colors (https://www.excelbanter.com/excel-programming/375905-user-forms-multipage-background-foreground-colors.html)

Bryan44

User Forms Multipage Background/Foreground Colors
 
I am building a 3 tab page User Form to get user input on pulling historical
data from another file. I noticed I can control the background color of the
User Form but cannot seem to control the colors of the Tab/Pages (the
multipages within the User Form). Anyone ever tried to do this before or
know how via code?

Sincerely,

Bryan

Tom Ogilvy

User Forms Multipage Background/Foreground Colors
 
To the best of my knowledge, control of this setting is not surrendered.

--
Regards,
Tom Ogilvy


"Bryan44" wrote in message
...
I am building a 3 tab page User Form to get user input on pulling
historical
data from another file. I noticed I can control the background color of
the
User Form but cannot seem to control the colors of the Tab/Pages (the
multipages within the User Form). Anyone ever tried to do this before or
know how via code?

Sincerely,

Bryan




Tom Ogilvy

User Forms Multipage Background/Foreground Colors
 
Some workarounds I have seen suggested is to use multiple frames instead of
a multipage. You can color the frames. Then use the frames to simulate a
multipage.


Another was to hide the tabs and use buttons or labels (which can be
colored) to simulate the tabs. This would only color the "tabs".

Also if you just want to color the page (not the tab), you can put in a
small colored bitmap on each page and tile it.

--
Regards,
Tom Ogilvy


"Tom Ogilvy" wrote in message
...
To the best of my knowledge, control of this setting is not surrendered.

--
Regards,
Tom Ogilvy


"Bryan44" wrote in message
...
I am building a 3 tab page User Form to get user input on pulling
historical
data from another file. I noticed I can control the background color of
the
User Form but cannot seem to control the colors of the Tab/Pages (the
multipages within the User Form). Anyone ever tried to do this before or
know how via code?

Sincerely,

Bryan






Bryan44

User Forms Multipage Background/Foreground Colors
 
Tom,

Thank you very much! I didn't think of that and that surely helps.

Bryan

"Tom Ogilvy" wrote:

Some workarounds I have seen suggested is to use multiple frames instead of
a multipage. You can color the frames. Then use the frames to simulate a
multipage.


Another was to hide the tabs and use buttons or labels (which can be
colored) to simulate the tabs. This would only color the "tabs".

Also if you just want to color the page (not the tab), you can put in a
small colored bitmap on each page and tile it.

--
Regards,
Tom Ogilvy


"Tom Ogilvy" wrote in message
...
To the best of my knowledge, control of this setting is not surrendered.

--
Regards,
Tom Ogilvy


"Bryan44" wrote in message
...
I am building a 3 tab page User Form to get user input on pulling
historical
data from another file. I noticed I can control the background color of
the
User Form but cannot seem to control the colors of the Tab/Pages (the
multipages within the User Form). Anyone ever tried to do this before or
know how via code?

Sincerely,

Bryan








All times are GMT +1. The time now is 04:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com