Thanks for the feedback.

Alternate non-vba method to enter static date/time in a cell

CTRL + ;..let go of CTRL, hit spacebar then CTRL + SHIFT + ;

Format to suit.


Gord

On Mon, 27 Nov 2006 08:15:39 GMT, "DAI via OfficeKB.com" <u29573@uwe wrote:

Gord,

That works well althogh I have canged the format of the date and time.

Sub NOWTIME()
ActiveCell.Value = Format(Now(), "dd/mm/yyyy hh:mm")
End Sub

Thank You


Gord Dibben wrote:
If you are clicking a button use a macro to insert a static time and not a
Function which can/will change.

Sub NOWTIME()
ActiveCell.Value = Format(Now(), "h:mm:ss AM/PM")
End Sub

Gord Dibben MS Excel MVP

Hello,

[quoted text clipped - 13 lines]

Any ideas would be welcome.

Gord Dibben MS Excel MVP