Code is not working ....

[wmbb]

I want to run the code below when a value is changed in a worksheet.
I want the changed cell to color blue, but nothing happens when a cell value is entered...

Can somebody tell me why ?

Private Sub Worksheet_Change(ByVal Target As Range)
    Target.Font.ColorIndex = 5
End Sub

 

[Andrzejek]

Text in the cell does change to [blue]blue[/blue] when I run your code (Excel 2010 on Win 7)


Have fun.

---- Andy

 

[strongm]

Change event does not trigger until you leave the cell

 

[wmbb]

Thanks for your support.
I had writen the code in module1 and it should be in the sheet code.
The problem is solved.