Inserting the system time

[Dazza]

Hi, I have a command button that executes a VB marco (it
refreshed price data). What code can I use so that the
time that the macro was executed, in format hh.mm.ss, is
displayed in cell P12?

Kind Regards,

 

[mudraker]

format p12 to the way you require it to display the time

use this code
range("p12")=now()

 

[Olly]

Range("P12").Value=Format(Now(),"hh.mm.ss")