کد:
Private Sub Worksheet_selectionChange(ByVal Target As Range)
Range("A1:E5").Interior.ColorIndex = 6
If Intersect(Target, Range("A1:E5")) Is Nothing Then Exit Sub
Select Case Target.Row
Case Is = 1
Range("A2:E5").ClearFormats
Range(Cells(Target.Row, "A"), Cells(Target.Row, "E")).Interior.ColorIndex = 6
Case Is = 2
Range("A1:E1", Range("A3:E5")).ClearFormats
Range(Cells(Target.Row, "A"), Cells(Target.Row, "E")).Interior.ColorIndex = 6
Case Is = 3
Range("A1:E2", Range("A4:E5")).ClearFormats
Range(Cells(Target.Row, "A"), Cells(Target.Row, "E")).Interior.ColorIndex = 6
Case Is = 4
Range("A1:E3", Range("A5:E5")).ClearFormats
Range(Cells(Target.Row, "A"), Cells(Target.Row, "E")).Interior.ColorIndex = 6
Case Is = 5
Range("A1:E4").ClearFormats
Range(Cells(Target.Row, "A"), Cells(Target.Row, "E")).Interior.ColorIndex = 6
End Select
End Sub
علاقه مندی ها (Bookmarks)