Entering Text and Date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Herschel ,

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

HTH,
Bernie
MS Excel MVP
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to enter start and end date/time in excel based on some specific value. 7
Access General Date Forced To Have Date And Time 2
Default date format 4
Excel Catagorise AM or PM 7
Suming Up Time over the course of days 1
Counting dates but only for a certain year 2
separating date and time 5
Insert date and time into cell with existing text 2

Back
Top