The original code you sent to me (below) will work if I toggle between YES and NO after doing the CLEAR
Well, of course. The Change Event Sub only runs after you change G3.

Add this line as the first line in the sub
Private Sub Worksheet_Change(ByVal Target As Range)
MsgBox"Running the Change sub."
'etc
'
Then Clear the cells