Hi,

i liked your VBA code and i am trying to use it for a project at work. i was playing around with your example, the Cat_Mouse.xlsm, and when i modified the 'myList' and 'myColor' arrays, it does not work.


for exmaple, i changed myList to = VBA.Array("Cat", "Mouse", "bat")
myColor = VBA.Array(vbRed, vbBlue, vbRed)

but the word "Bat" is not colored red. interestingly enough, when i substitute the word "bat" for the word "hat", the word "hat" does change to the red font. any ideas?

i am looking to use this code to address keywords in my excel file by coloring all key words red and i have more than 10 key words.