VBA代码如下:
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
Dim i
i = Target.Row
If Target.Column = 1 Then
Range("A" & i) = Range("A" & i) * 40
Else
If Target.Column = 2 Then
Range("B" & i) = Range("B" & i) * 50
End If
End If
Application.EnableEvents = True
End Sub
2. 效果如图所示: