Solved: Capture System Time

[rahullambe]

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.

[Bob Phillips]

[vba]

Sub Time()
With ActiveCell

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

[Paul_Hossler]

Maybe ...


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

Paul

[rahullambe]

Maybe ...


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

Paul

Thanks;

Its working.........

Thanks a lot..