Thread: Date/time Macro

Greetings,
What is the code i need to use to assign a macro to a command button which inserts the current date and time in the selected cell regardless of where that cell is?
Much obliged.

Code:

Sub Macro6()
'
' Macro6 Macro
'

With ActiveCell
    .NumberFormat = "[$-409]m/d/yy h:mm AM/PM;@"
    .Value = Now()
    .ColumnWidth = 15#
End With
End Sub

Hi,

One way:

Code:

ActiveCell = Format(Date, "dd/mm/yyyy") & " : " & Time

HTH