Managing TIme Accuracy

Hi,

I have a toggle button on a spreadsheet. I hit it and store Date + Time / Now in a variable then when I hit it again I store time in another variable. For some reason I cannot get this to accurately capture the time. It is accurate technically but, I lose 2 seconds just in "Excel thinking". I've turned off all the code event hadnling and Its 2 seconds just to toggle on update screen and toggle off. If I turn off screenupdating and events I'm up to 3 seconds.

Anyone have any ideas on eliminating just this "cycle" time?

Is there anything else in the VBA code prior to the time being written to the variable that might cause a recalculation? If so, could the code be rewritten to put the writing to variable first?

This does help, oddly. Although I have no real calcs running, turning calcs to manual before hand gets me down to 1 sec of "missing" time.

.
.
This small project uses a UserForm and CommandButtons. The "time stamp" is instantaneous.

Wonder if your Toggle Button has something to do with the time lag ?

Please Login or Register  to view this content.

Yeah, sadly looks like it's something with the toggle button. I cannot get it to zero. Excel x VBA is a frustrating mistress

That's hard to explain, in short too much, but it runs in less than a sec. Workbook is too much to post here and if I scale it down won't make sense. I think I'm going to chalk it up to the laws of physics for now. Thanks for your help