I am using a 'Private Sub Worksheet_Change' and a part of the code is below.
I want to adapt this code to be able to wait until A1 = 1, then execute, Range("A2").Value = "Yes"
How can I do this?
Code:
If Range("A1").Value = 1, Then
Range("A2").Value = "Yes"
I want to adapt this code to be able to wait until A1 = 1, then execute, Range("A2").Value = "Yes"
How can I do this?