Macro inserts date based on cell value

Currently I have the following macro that inserts a date in a cell as soon as another cell is clicked.
However I need it to only insert the date if the cell value is equal to COMPLETED.

Current macro.

Please Login or Register  to view this content.

Based upon your post it sounds to me like you would be better suiting using the Worksheet Change event instead of Worksheet SelectionChange

tRY:

Please Login or Register  to view this content.

Originally Posted by stnkynts

Based upon your post it sounds to me like you would be better suiting using the Worksheet Change event instead of Worksheet SelectionChange

tRY:

Please Login or Register  to view this content.

Works perfectly. Thanks,