Entering Text and Date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Herschel Lawhorn - 19 Apr 2007 17:50 GMT

I need a macro that will enter some text "Uploaded" and the date and time in
this format "The text" date time such as Uploaded 04/19/07 12:42 PM. I don't
want this time to change after it is entered"

Can any one help?

Reply to this Message

Bernie Deitrick - 19 Apr 2007 18:26 GMT

Herschel ,

Sub EnterUpload()
ActiveCell.Value = "Uploaded " & Format(Now, "mm/dd/yy h:mm AM/PM")
End Sub

HTH,
Bernie
MS Excel MVP

>I need a macro that will enter some text "Uploaded" and the date and time in
> this format "The text" date time such as Uploaded 04/19/07 12:42 PM. I don't
> want this time to change after it is entered"
>
> Can any one help?

Reply to this Message

Herschel Lawhorn - 19 Apr 2007 22:22 GMT

Thanks Bernie, That works great.

> Herschel ,
>
[quoted text clipped - 11 lines]
> >
> > Can any one help?

Reply to this Message

Rate this thread: