+ Reply to Thread
Results 1 to 3 of 3

Cell Color Change Macro not working after changing one word

  1. #1
    Registered User
    Join Date
    06-12-2019
    Location
    Stockton, England
    MS-Off Ver
    16.25
    Posts
    2

    Cell Color Change Macro not working after changing one word

    Hi guys first post and very much not an expert in Excel Macros

    I have a macro that is used by an organisation (A). Another organisation (B) is wanting to use the macro and the wording on the spreadsheets is different by 1 word

    Organisation A uses - "MYWAY BREAKFAST"
    Organisation B uses - "MYWAY"

    The original Macro for Organisation A will auto populate a spread sheet and any instances of the words below will turn green:

    "Breakfast Inclusive"
    "Myway Breakfast"
    "Voucher 1"
    "Voucher 2"

    I figured I would just be able to change "Myway Breakfast" to "Myway" and this would work instantly however the following happens

    -The 4 keywords still auto populate as needed (GOOD)
    - ONLY "Breakfast Inclusive" now turns green and the other 3 keywords dont change color (BAD)

    Code is below after I edited to just be "MYWAY"

    Any help would be greatly appreciated! YOU DA BEST!

    ------

    Please Login or Register  to view this content.
    End Sub
    Last edited by alansidman; 06-12-2019 at 04:33 PM.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,873

    Re: Cell Color Change Macro not working after changing one word

    Code Tags Added
    Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

    Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



    (I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    06-12-2019
    Location
    Stockton, England
    MS-Off Ver
    16.25
    Posts
    2

    Re: Cell Color Change Macro not working after changing one word

    Thankyou! hugely appreciated.

    A

+ 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. Need help changing cell color based on percentage change
    By mnhim001 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-22-2015, 05:24 PM
  2. Macro to change cell text color based on darkness of cell fill color
    By cincyshirm61 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-25-2014, 12:11 PM
  3. Replies: 5
    Last Post: 09-24-2013, 03:42 PM
  4. VBA / Macro help needed to change the barchart color based on Cell Color
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-28-2012, 09:15 AM
  5. Change the color of a cell with changing its value
    By skumar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-17-2009, 02:08 AM
  6. changing cell color by word
    By e2the1stpower in forum Excel General
    Replies: 3
    Last Post: 04-30-2008, 06:32 AM
  7. [SOLVED] macro -find all occurences of a word-change color of cell of all
    By Lost in Alabama in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-17-2006, 09:50 AM

Tags for this Thread

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