Clear Cell Contents Based On Criteria

Hi

I'm guessing the solution to my question will be VBA code so have enteerd it on this forum (hopefully it's the right place).

Can someone please tell me how I can clear the contents of one cell on a row dependent on a specific value being entered in another cell on the same row. Example:

Value in C1 is "Yes". If a date is entered in to cell M1 the value of C1 should be cleared.

Thanks.

Originally Posted by Steffen Thomsen

Hi,

You can do it with this

Please Login or Register  to view this content.

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?

Worked! Thanks very much for your help Steffen

Just wondering, how can I have two of these instances on one worksheet?

So C1 would already have turned blank as a date had been input into M1. But a later part of the process a “Yes” needs to go in R1 but, as soon as a date is input in Y1, I need R1 to go blank too.

So this is two separate processes, C1 and M1 would always be completed before R1 and Y1.

I tried just copying and pasting the same code in twice for the worksheet but got an error.