|
- Private Sub Worksheet_Change(ByVal Target As Range)
- On Error Resume Next
- Dim rng As Range
- If Target.Row > 7 Or Target.Count > 1 Then Exit Sub
- Select Case Target.Column
- Case 7
- Set rng = Range("b2:b6").Find(Target, , , xlWhole)
- rng.Offset(0, 1).Interior.ColorIndex = 3
- Case 8
- Set rng = Range("b2:b6").Find(Target, , , xlWhole)
- rng.Offset(0, 2).Interior.ColorIndex = 3
- Case 9
- Set rng = Range("b2:b6").Find(Target, , , xlWhole)
- rng.Offset(0, 3).Interior.ColorIndex = 3
- End Select
- End Sub
复制代码 复制代码到所在的工作表模块中。 |
|