Interior Color change doesn't work in Case Statement

Hello, i want to change the cell color of different letters, an example is :

case i type in the range "k", set the interior color to an rgb.
Here the code :

Please Login or Register  to view this content.

Use Font instead of Interior if you want to change the color of character. The Character don't have Interior property.

I want to change background color.

Originally Posted by Lomoo

I want to change background color.

What, behind each individual character? If that is what you are after, it cannot be done... a cell can only have a single fill color.

It's impossible.

Maybe I'm not being clear. I have a cell and in this cell i type a letter, with the Sub Worksheet_Change(ByVal Target As Range) i have to put a code that recognize that letter and change it's background color, not the font color.

Okay, so are you saying you want to continually change the background color with each letter as you type them into a single cell? If so, you cannot do that either. VBA code does not run while a cell is in edit mode. The change in the Change Event refers to the value in the cell after that value has been fully entered into the cell.