Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Coulmn <>3 Then Exit Sub 'Sets range to column "C" adjust for your needs
If Target <> "Yes" Then
Target = "Yes"
Else: Target = ""
Cancel = True
This will toggle between "YES" and a blank when cell is doubleclicked