Inserting the system time

D

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,
 
M

mudraker

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

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