If Range("E7") > 0 Then
Range("G7") = Range("E7")
ElseIf Range("E7") < 0 Then Range("H7") = Range("E7")
End If
If Range("E7").Value > 0 Then
Range("G7").Value = Range("E7").Value
If Range("E7").Value <= 0 Then
Range("H7").Value = Range("E7").Value
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
If Target <> [E7] Then Exit Sub
If [E7] > 0 Then [G7] = [E7]: [E7] = 0
If [E7] < 0 Then [H7] = [E7]: [E7] = 0
Application.EnableEvents = True
End Sub
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
With Target
If .Address = "$E$7" Then
Application.EnableEvents = False
If .Value > 0 Then
Range("G7") = .Value
ElseIf .Value < 0 Then Range("H7") = .Value
End If
Application.EnableEvents = True
End If
End With
End Sub