![]() |
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 |
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 |
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 |
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