2,462
社区成员
发帖
与我相关
我的任务
分享
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
Cells(Target.Row, 3).Select
ElseIf Target.Column = 3 Then
Select Case Target.Text
Case "出"
Cells(Target.Row, 5).Select
Case "入"
Cells(Target.Row, 8).Select
Case "存"
Cells(Target.Row, 11).Select
Case "取"
Cells(Target.Row, 12).Select
End Select
ElseIf Target.Column = 5 Or Target.Column = 8 Or Target.Column = 11 Or Target.Column = 12 Then
Cells(Target.Row + 1, 1).Select
End If
End Sub