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

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