get clock in seconds in VBA

[iceman]

Hi,

how can I get in VBA the clock ins seconds? I know ho to do in excel, but I need to do that in VBA, because if i chek excel cells, when load a new market it's a problem....

Thanks anyway

[osknows]

MyTime = Format(Now, "dd-MMM-yyyy HH:mm:ss") - gives time to the second


MyTime = Format(Now, "dd-MMM-yyyy HH:mm:ss") & "." & Right(Format(Timer, "#0.00"), 2) - gives time to the millisecond

[iceman]

Thank you very much Osk!

[osknows]

I should have said that the Format converts the data/time to a string. If you need it as a date type just use

MyTime = Now

[alrodopial]

Or as number:
string*1