Entering Text and Date

H

Herschel Lawhorn

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?
 
B

Bernie Deitrick

Herschel ,

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

HTH,
Bernie
MS Excel MVP
 
H

Herschel Lawhorn

Thanks Bernie, That works great.

Bernie Deitrick said:
Herschel ,

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

HTH,
Bernie
MS Excel MVP
Click to expand...
 
Top