Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Option Explicit
Dim I As Integer Dim Add As String Private Sub Worksheet_SelectionChange(ByVal Target As Range) For I = 1 To 9 Select Case I Case 1: Add = "$A$1" Case 2: Add = "$B$1" Case 3: Add = "$C$1" Case 4: Add = "$D$1" Case 5: Add = "$E$1" Case 6: Add = "$F$1" Case 7: Add = "$G$1" Case 8: Add = "$H$1" Case 9: Add = "$I$1" End Select If Target.Address = Add Then Target.Font.ColorIndex = 1 ' black text Else Range(Add).Font.ColorIndex = 15 'grey text End If Next I End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I show/hide the cell comment blocks ? | New Users to Excel | |||
show or Hide cell comment when mouse hovers in Excel? | Excel Worksheet Functions | |||
how do I hide the #N/A to not show in the cell | Excel Worksheet Functions | |||
How do you show/hide individual cell gridlines in Excel 2007? | Excel Discussion (Misc queries) | |||
Show/Hide a Secret Cell | Excel Programming |