Hello,
Quick question:
The following code DOES work BUT I have to go into VBA and run the command manually for the If statement change to actually execute.
What I want is for this to execute automatically, meaning that If A13 = "Test" Then I want it to automatically execute the Next line whereby the Cell A14 will change its value to "Done". What am I missing in this code here?
Thanks in advance
Private Sub ActiveSheet_Change()
If Range("A13").Value = "Test" Then
Range("A13").Offset(1, 0).Value = "Done"
End If
End Sub
Bookmarks