View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Erick Erick is offline
external usenet poster
 
Posts: 2
Default Grab Time with milliseconds included in VBA

I read one post that had a formula like "=TEXT(NOW(),"SS.00")", that
works, but I can not find anyway to use VBA to include milliseconds in
the time. I have tried worksheets("sheet1").cells(1,1) =
format(Time,"SS.00") and simular code but still can not get vba to
give me the milliseconds.


Thank you,
EKlassen