Solved: Capture System Time

Dear friends,

In my excel sheet; I want to assign macro for form button; if I click this button, then I should get system time on the next column of the button.

Attached is the file for your reference.

Please help me.

Thanks.:help

[vba]

Sub Time()
With ActiveCell

.Value = Now
.NumberFormat = "h:mm AM/PM"
End With
End Sub
[/vba]

Maybe ...


[VBA]
Sub Time()
ActiveSheet.Range("D4").Value = Format(Now, "hh:mm ampm")
End Sub
[/VBA]

Paul

Quote:

---

Originally Posted by Paul_Hossler

Maybe ...


[VBA]
Sub Time()
ActiveSheet.Range("D4").Value = Format(Now, "hh:mm ampm")
End Sub
[/VBA]

Paul

---

Thanks;

Its working.........

Thanks a lot..