macro to color all specific letters in a range of text

Hello,

I'm trying to set up a macro to color all specific letters in a range of text in one cell. So for example the text ERFLEEWLEFDE, I want to give all the "E" a blue font color and font = bold.
the macro code I came up with only colors the first "E" it finds.
who can help me with some changes in the code to color all the "E" in the text.

thanks in advance

text in cell: ERFLEWLEFDE

code so far:

Please Login or Register  to view this content.

Hello,

I'm sorry,
trying to fix it but it then the site is blocked..?

Hello,
thanks for your help,
it isn't working, it stuck on (If .Characters(k, 1) = "E" Then)
error: runtime error 438. object doesn't support this property or method

Thanks for your help

it works!

It's Working

Thanks for the help!

This will work now.. just needed to replace the "1" with the "j" variable..

Please Login or Register  to view this content.

dear Millz,

the code is working nice,
is it possible to select more letters in once? like the "E" and the "D" ant maybe other letters?

thanks

Hi..
Did you try my code..? I am pretty sure it does what you want..

To select more letters.. just add the "Or" operator..

Example:

Please Login or Register  to view this content.

Hey Apo,

I'am trying to put it in a toggle button like the code here:
it gives an error; Next without for?
can you help

Please Login or Register  to view this content.

hi.. watching a movie right now.. ..

but just quickly.. remove the first "Next f" and move the secondd "Next f" below the "End Select" statement.. thats a start anyway..

Hi,

Not working yet, I will wait till end of the movie
thanks

It's working thanks,
but if the value of the cells in column G is linked to another cell t gives error 1004 unable to get caption property of the characters class
can you help me with this error