Modify code to erase data when another cell is cleared

[Nitefox]

I am currently using the following code to add todays date into D when data is entered into G.

Please Login or Register  to view this content.

How can I modify it so that if the user erases the data in G then the date in D is also cleared?

[berlan]

Would this work?

Please Login or Register  to view this content.

[TMS]

If you make a change to a cell within the Worksheet Change event handler, you should use

Please Login or Register  to view this content.

before, and

Please Login or Register  to view this content.

after the change.


Regards, TMS

[berlan]

Nice inputs TMShucks. With that in mind:

Please Login or Register  to view this content.

[TMS]

@berlan: You're welcome.

[Nitefox]

Thank you for you responses. I tried that code, and while it will add the date when data is entered its not erasing it.
I have attached my worksheet. The sheet in question is ReturnData. (hit Start Scan at the top to find the next empty row in G, and type in 58883)

TMShucks out of interest why is the Application.EnableEvents code required? Ive been using that original code without any issues.

[berlan]

Sorry, I am afraid that I misunderstood you. I thought you also wanted to clear column G if you cleared the date.

This may work:

Please Login or Register  to view this content.

By setting the Application.EnableEvents to false, it won't trigger any events that might occure by adding data to column D within the routine, in this case.

[Nitefox]

Perfect, that did it. Thank you.

[berlan]

Anytime, Nitefox! Glad it worked