If cell not empty, display today's date in adjoining cell

[jmueller0823]

So, this was solved in another post, but I can't locate it to make a reply.

The code below solved the issue.

I created a macro with this, and the date does not insert. I have several sheets in the workbook; Do I need to specify the specific sheet?

This is what I need:
Sheet name = Actions
If Column D is not empty, display today's date in Column E.

Thanks!

Please Login or Register  to view this content.

[alansidman]

You have posted a worksheet change event. This is particular to an individual sheet. If you have more than one sheet that needs to be appended, then this code will need to be in each sheet. In order for this code you need to have something change manually in Column D, otherwise as the code indicates it exits the code.

[jmueller0823]

Several sheets, but I only want the macro to act on one sheet: Sheet#1 "Actions"
Does this need to be indicated in the code?

And yes, I understand a manual action needs to occur in Column D, that's how I am testing.

Should I create and paste this into a macro? Or should I do this in the VB editor? Does it matter?

Thanks.

[alansidman]

Put it in the worksheet events for the particular worksheet. Open VBE, click on the particular sheet in the left window. Paste the code into the right window. Close and Save.

[jmueller0823]

Put it in the worksheet events for the particular worksheet. Open VBE, click on the particular sheet in the left window. Paste the code into the right window. Close and Save.

Success! Thank you.

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[jmueller0823]

Please disregard.

[AliGW]

The thread is marked as solved - I suggest you change that if you want to attract further help.