+ Reply to Thread
Results 1 to 3 of 3

Change tab forecolor multipage UserForm

  1. #1
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Change tab forecolor multipage UserForm

    Hello Guys,

    I tried to change the tab's forecolor when I click on it in multipage UserForm but I can't!
    The users complain that they do not know which page is active taking into account that the page's color can't be changed completely.
    Scenario: the forecolor Page1,Page2,Page3 is black, when I click on any Page the color to be in red and the rest of tehm to be black.
    Have any idea how I can get it?

    I appreciate your time and help.
    Attached Files Attached Files
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Change tab forecolor multipage UserForm

    Hi John

    I was looking for something like this the other days and look what i found.

    here & here
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: Change tab forecolor multipage UserForm

    Thx Fotis!
    I do not want to change the color of page(s), easily can be done adding a frame and color it but the tab strip remains unchanged, this is the reason I avoid it.
    All I want is to have a different (text of tab strip) color of active page...

    posted here too:http://www.thecodecage.com/forumz/sh...post1055010369
    Last edited by john55; 02-24-2014 at 07:30 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Change position of Multipage on userform
    By johnny_p in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-19-2014, 05:43 PM
  2. [SOLVED] Change background image on individual multipage userform pages using vba
    By sbrennan970 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-11-2013, 06:50 AM
  3. Change listItem forecolor based on criteria
    By ioncila in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-15-2012, 10:03 AM
  4. Userform Multipage Event Change
    By sepandb in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-31-2008, 01:40 PM
  5. Formula to change RGB to/from .Fill.Forecolor?
    By Air_Cooled_Nut in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-29-2006, 01:12 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1