excel中输入数值自动关联变为负数？求解答!

代码 Private Sub Worksheet_Change(ByVal Target As Range) For i = 1 To 100 If Target.Column = 1 And Target.Cells(i, 1) = "支出" Then Target.Offset(0, 1) = Target.Cells(1, 2) * -1 End If Next For i = 1 To 100 I