Macro that automatically inputs "RECHECK STATUS" in cell when date changes in another cell

[mhitz]

Hello,

I am having trouble figuring out code to have excel automatically input "RECHECK STATUS" in one cell when the date changes in another cell.

The dates will be in column D, and "RECHECK STATUS" will be in column E.

So, for example, if a user changes the date in cell D6, how can I make excel automatically input "RECHECK STATUS" in E6?

And, for example, if a user changes the date in cell D15, how can I make excel automatically input "RECHECK STATUS" in E15? (Notice I am trying to make this work for the full range of columns D and E).

Also, I would like the ability to delete "RECHECK STATUS" after status is checked.

Thank you to anyone who can come up with a solution.

[TMS]

Please Login or Register  to view this content.

Regards,TMS

[mehmetcik]

This is a sheet specific macro.

Enter anything in column D and Column E will ask to Check Status.

Enter Ok into Column F will Clear entries in Column E and F.


Because it is worksheet code, it is very easy to install and automatic to use:

1. right-click the tab name near the bottom of the Excel window
2. select View Code - this brings up a VBE window
3. paste the stuff in and close the VBE window

Please Login or Register  to view this content.

[TMS]

Please note that if you make changes to cells on the sheet within the Change event handler, you need to disable event handling before you make the change(s) and re-enable it afterwards. If you do not do this, you can cause a loop which, at best, will cause a slight delay and, at worst, may cause Excel/VBA to fail.


Regards, TMS

[mhitz]

Thank you very much. You even threw in another great technique for validating check status. How can we make "Check Status" red and bold?

[mhitz]

Thanks very much! Works great. How can we make "RECHECK STATUS" red and bold?

[mehmetcik]

Try This.

Please Login or Register  to view this content.

[TMS]

Not tested but combining mine and other's solutions:

Please Login or Register  to view this content.

Regards, TMS