Sub GState()
If Range("F81") + Range("F82") > 0 Then
Range("H93").Value = "IP"
Else
Range("H93").Value = "GE"
End If
End Sub
I want to make this code dynamic so that the moment when the result changes from "IP" to "GE" is recognised and "END" is outputted into "H94". The code would need to be re-checking for the change in state continuously every second or so.
Can anyone help with adapting this code?
If Range("F81") + Range("F82") > 0 Then
Range("H93").Value = "IP"
Else
Range("H93").Value = "GE"
End If
End Sub
I want to make this code dynamic so that the moment when the result changes from "IP" to "GE" is recognised and "END" is outputted into "H94". The code would need to be re-checking for the change in state continuously every second or so.
Can anyone help with adapting this code?