Forum Discussion

bakerbaker19's avatar
bakerbaker19
Copper Contributor
Dec 10, 2019
Solved

VBA Code Help - Changing Color of Certain text and characters after specified text

So I am partially VBA savvy but this code seems way over my skill level. I am trying to find the text "ETIC-" in any cell and change it blue; the catch is, that I also want any character that follow...
Macros and VBA
  • Rich99's avatar
    Rich99
    Dec 12, 2019

    Hi bakerbaker19 

     

    Have attached a revised macro (Test2) which I think should work for every case.

     

    Rich

bakerbaker19's avatar
bakerbaker19
Copper Contributor
Dec 11, 2019

Rich99 After investigating what was going wrong, I finally figured it out and your code works!....most of the time. I don't know why but sometimes it doesn't highlight the last 1 to 3 characters before the "/". Do you have any idea what would cause this? (Thanks for the code though as it works 95% of the time!)

Rich99's avatar
Rich99
Iron Contributor
Dec 12, 2019

Hi bakerbaker19 

 

Have attached a revised macro (Test2) which I think should work for every case.

 

Rich

  • Khanh_Mai's avatar
    Khanh_Mai
    Copper Contributor
    Dec 06, 2020

    Hi Rich99,


    In my case, can you please show me how to format text in "Italic" and color for the text for all the text starting from the second line in the cell. It is applied for all the text in a specified column. 

    Please see the attached file

     

     

     

    Many thanks.

     

    KM

     

  • bakerbaker19's avatar
    bakerbaker19
    Copper Contributor
    Dec 12, 2019

    Rich99 This one works perfectly! Thank you for all of your help!