Removing time in cell

Hi everyone,

I have some code that display date and time in a cell when "done" is input into the adjaecent cell. (Any value would be the trigger, though)

Please Login or Register  to view this content.

Can this be altered so that when "done" is deleted in the adjaecent cell the time/date is removed. At the moment you have to do it manually.

Thanks in advance

Hello bigbadlee,

This will recognize only "Done" in the cell. It is not case sensitive. Any other value will clear the adjacent cell. To prevent a cascade failure, I have added Application.EnableEvents to the macro. This will prevent the macro from calling itself over, and over when the cell value is changed.

Please Login or Register  to view this content.