|
- Private Sub Worksheet_Change(ByVal Target As Range)
- Dim arrInfo As Variant
- If Target.Column <> Cells(1, "G").Column Then Exit Sub
- If Target.Count = 1 Then
- Cells(Target.Row, "A") = IIf(Target = 1, -1, "")
- Else
- arrInfo = Target
- Application.EnableEvents = False
- For i = Target.Row To Target.Row + UBound(arrInfo)
- Cells(i, "A") = IIf(Target.Cells(i + 1 - Target.Row) = 1, -1, "")
- Next
- Application.EnableEvents = True
- End If
- End Sub
- Private Sub Worksheet_SelectionChange(ByVal Target As Range)
- If Target.Count > 1 Then Exit Sub
- If Target.Column = 1 And Target = -1 Then
- Target.Offset(0, 1).Activate
- End If
- End Sub
复制代码 |
|