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
  • 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!)

      • Khanh_Mai's avatar
        Khanh_Mai
        Copper Contributor
        Dec 07, 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

         

    • Rich99's avatar
      Rich99
      Iron Contributor
      Dec 12, 2019
      No idea I'm afraid but can you attach a sample of where it doesn't work

      Rich
  • bakerbaker19's avatar
    bakerbaker19
    Copper Contributor
    Dec 11, 2019

    Unfortunately it does not. I am getting an error of "Run-time error '9': Subscript out of range" and it highlights this row "Out.Characters(x, Len(LArray(1))).Font.ColorIndex = 5 Rich99 

Resources