Here's my code to write the actual time in a new cell each 5 minutes, I have two open questions about it:
Application.OnTime Now + TimeValue("00:05:00"), _
[A65536].End(xlUp)(2) = Now
Now, I'd like to be able to change the time by changing the value in a cell and avoid changing the code each time I want a new update time.
Second question: Can I have a button which could stop the macro when clicked? How?
Can anyone help?