Date Time of Last Execution
 

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

Date Time of Last Execution
 

Within the macro include something like:

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

pick any cell in place of A1
--
Gary''s Student


"JB2010" wrote:

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