PC 's Time

bahachin · April 26th, 2005, 09:54 AM

  I am using Excel 2000 to write the Pc's Time on cell , say,
"B12" in Sheet1.
     This is the code I wrote;-

    Range("B12").value = Time

   However, the Pc's time keeps running as each second elapses.
  Is there a code that shows a static current Pc's time?
  This is equivalent to pressing the shortkey Ctl+Shift+; to show the Pc's static current time.
    Appreciate asistance from all gurus!

BrianWren · April 26th, 2005, 11:20 AM

I would try

Code:

    Range("B12").value = Format(Now, "hh:mm:ss")

bahachin · April 27th, 2005, 01:37 AM

Thank you very much, Brian, for your help.

In fact, I have tried that code once on another Pc, but the PC's time still runs.
However, this time when I tried a test run on my present Pc, after having a concurrence of view with you, it works wonderfully!

I need to check the motherbaord of the other Pc.

You are a great help!

CHIN