Date Time of Last Execution

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi


Is there a way to log the date time a macro was run?

For example, i have a button that fires off a macro, the user selects when
to hit the button, but the choice to hit it may be based on how much time has
elapsed since it was last hit. If i could put a date / time in an adjacent
cell to the button, users could make a more informed choice.

Any help gratefully recieved. If you need more info, please do not hesitate
to contact me


cheers


jb
 
Within the macro include something like:

Range("A1").Value = Now()

pick any cell in place of A1
 
Back
Top