Record date last time button was clicked

**MaddyG** · 01-20-2013, 11:08 PM

I have a button in "Sheet1", that performs an advanced filter on that sheet from data in another sheet..

I'd like to have the cell next to that button, which is cell "C1" record the last time that button was pressed.
There may be times the button is pressed where the data doesn't change, so I was thinking recording the last time the range or cell was modified, might not do the trick (which is all i found when doing my own searches - none of which i could get to work anyway).

Seems like a simple problem, but having a ton of difficulties figuring out on my own.

**HaHoBe** · 01-20-2013, 11:14 PM

Hi, MaddyG,

what about adding this line of code:

Please Login or Register  to view this content.

If you only want the time use Time instead of Now. If the data is changed directly you could use the Worksheet_Change-Event on that sheet to monitor the time to the cell.

Ciao,
Holger