how to make a sub or function that acts as a timer

[dmcgov]

I would like to time my macro, so im looking for a VBA way to put a start time in a cell and the end time in a cell. then figure out the time difference between the two cells.

i know that there is a way to enter in time by doing a Ctrl Shift Colon and that puts a time stamp in the associated cell. is there a way to do this with VBA and just put the start and end times for the macro and then have a formula that returns the difference between the start and end?

so what i got working is kind of a hack (but it works). see both commands below. is there a better way to do this?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Izandol]

Please Login or Register  to view this content.

is sufficient. You may also use Timer in VBA or GetTickCount API.

[dmcgov]

thanks izandol, that looks like the easiest to implement.