Clear Cell Contents Based On Criteria

Originally Posted by Steffen Thomsen

Hi,

You can do it with this

Private Sub Worksheet_change(Byval target as range)
   if target.column = 13 and Range("C" & target.row) = "Yes" then
       Application.EnableEvents = False
       Range("C" & target.Row).ClearContents
       Application.EnableEvents = True
   end if
end sub

Thanks for your reply but I can't get this code to work. Maybe because I'm not use to VBA coding/macros in excel. Maybe you can see if I've done something wrong:

I opened the relevant worksheet
I then accessed the VBA Editor (Alt+f11)
I selected "Insert User Form" > "Module"
Then pasted your code
Saved then closed the workbook
Then re-opened and selected "Enable Macros" and entered data to test but the data in column "C" doens't disappear.

Where have I gone wrong?