Help with color.... 1

[JrClown]

I've tried changing the number in bold below and it only seem to take specific number, is there a pre-set number that are associated with color??

Oh by the way, this litte code snip highlights a cell in excel when selected with the keyboard and or mouse.

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Excel.Range)
Static OldCell As Range

If Not OldCell Is Nothing Then
OldCell.Interior.ColorIndex = xlColorIndexNone
End If

Target.Interior.ColorIndex = 20

Set OldCell = Target


End Sub

"The reward of one duty done is the power to fulfill another"
<%
Jr_Clown@Yahoo.com
%>
​

 

[JustinEzequiel]

according to the Excel help file, you can set the colorindex property to xlColorIndexNone, xlColorIndexAutomatic or to any integer value from 1 to 56 inclusive

 

[TonyU]

Very nice JustinEzequiel. Thanks dude. Tony