+ Reply to Thread
Results 1 to 2 of 2

VBA to highlight specific words within a certain range (inkl reset to old format)

  1. #1
    Registered User
    Join Date
    09-20-2016
    Location
    Frankfurt
    MS-Off Ver
    Mac 2016
    Posts
    26

    VBA to highlight specific words within a certain range (inkl reset to old format)

    Dear Everyone

    I am trying to come up with a VBA that allows me to color code (highlight) my data output based on a relatively large list of unique words.
    Also, my ambition is to have it as an on/off switch or something so I could revoke the highlighting of these words again.

    Any one out there who might know how to do that?

    I have tried using conditional formatting, but the "applies to" range never stays fixed for some reason (maybe due to other macros I am running as well)...hence now I am trying to go the VBA-way

    Thank you so kindly in advance!

    Best
    Daniel

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,908

    Re: VBA to highlight specific words within a certain range (inkl reset to old format)

    Any one out there who might know how to do that?
    We might if you can provide us with an example file so we have something to work with.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

+ 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] Cond Format for specific words-
    By thursday140 in forum Excel General
    Replies: 3
    Last Post: 10-24-2017, 08:53 AM
  2. [SOLVED] I need to create a reset button that will reset rows containing a specific value
    By odin78 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 04-03-2016, 02:11 PM
  3. [SOLVED] Macro usage in order to highlight/format particular words in cell
    By chancechristensen in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-16-2015, 09:36 PM
  4. Replies: 0
    Last Post: 04-29-2013, 03:13 PM
  5. Replies: 3
    Last Post: 09-28-2012, 02:13 AM
  6. search & highlight specific words from list in workbook
    By venexcel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-27-2012, 02:34 PM
  7. Highlight a row if a specific cell is specific numbers/words
    By sea0221 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-08-2005, 09:06 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