Calculate in a form them execution time of a Macro

[asn3068]

(sorry for my english, i'm from Spain)...I need to see in a form the execution time of a macro that runs from a boton on this same form. <br>
The cicle would be:<br>
1. Click the buton<br>
2. The chronometer/field starts and the macro run<br>
3. End the macro<br>
4. The time stopped and visible in the form.<br>
<br>
Thanks for you response and for read this questions.

 

[JimHorton]

asn,<br>
Do this, in the Click event:<br>
dim stime as date, etime as date<br>
stime = now()<br>
<br>
run macro<br>
<br>
etime = now()<br>
<br>
me!elapsedtimefield = etime - stime<br>
<br>