Results 1 to 3 of 3

VBA change tab colour to RGB value based on tab name

Threaded View

  1. #1
    Registered User
    Join Date
    07-17-2019
    Location
    Canada
    MS-Off Ver
    Office 365
    Posts
    9

    VBA change tab colour to RGB value based on tab name

    I'm looking for a VBA solution that I can run for an entire workbook, which will change the tab color to an RGB value if it contains part of a name. I'm guessing this would be a separate module. There are two modules in my workbook already.

    My tab names all end with three or two letters. Preceding them is a number and/or other text. But there are only 10 types of "names" I want to look for.

    Examples of tab my names are "11 atOTT" or "8 vsTOR". I want to be able to set an RGB color for the tab if it contains "OTT" or "TOR" etc. Those are two of the 10 I would like to set.

    Thanks.
    Last edited by Copernicus19; 07-19-2019 at 12:53 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Change Segment colour based on value
    By jamesa2487 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-20-2017, 02:25 PM
  2. How to change cell colour, if the colour is based on value from formula?
    By darah237 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-19-2016, 11:40 AM
  3. Replies: 6
    Last Post: 04-11-2016, 09:48 AM
  4. Change colour of cells based on another cell's colour (Not value)
    By LTrain89 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-25-2013, 08:44 PM
  5. Colour change column chart based on cell colour
    By Alice21 in forum Excel General
    Replies: 11
    Last Post: 04-05-2011, 10:10 AM
  6. How to make row change colour based on text colour in row?
    By Joanna13 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-02-2010, 04:39 PM
  7. how to change colour based on date
    By dgdonnelly in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 10-04-2008, 04:28 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