Connect with like-minded education professionals and have your say on the issues that matter to you.
Don't forget to look at the how to guide.
Discussion in 'Computing and ICT' started by madcat, Oct 16, 2011.
You could use the ASC() function to get the ASCII value of the letters
ASC("A") will return 65 etc
i have had a go at putting some other code which works as long as its targetting 1 column. would you happen to know how to target all colunms
this is the code i am using:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column <> 1 Or Target.Cells.Count > 1 Then Exit Sub
Select Case UCase(Target.Value)
.ColorIndex = 3
.ColorIndex = 10
.ColorIndex = 5
.ColorIndex = 6
.ColorIndex = 0