Hi, I have an order sheet that I want to have the date added t
automatically as an order is entered.
The date just has to be timilar to Microsoft Excels TODAY() functio
but only entered once and not changeable after...

I need the code to generate 'todays date' for entry into the sheet
instead of having the user type the date in.....

is this possible

--
Message posted from http://www.ExcelForum.com

It's easy to enter a date with code:

Sub EnterDate()
Range("A1").Value = Now
End Sub

This assumes that the cell already has the date format you want.

How you're going to make this code run is a more interesting question.

--
Jim Rech
Excel MVP

"Souljah " wrote in message
...
| Hi, I have an order sheet that I want to have the date added to
| automatically as an order is entered.
| The date just has to be timilar to Microsoft Excels TODAY() function
| but only entered once and not changeable after...
|
| I need the code to generate 'todays date' for entry into the sheet,
| instead of having the user type the date in.....
|
| is this possible?
|
|
| ---
| Message posted from http://www.ExcelForum.com/
|

CDate(Now)

HTH, Greg

"Souljah " wrote in message
...
Hi, I have an order sheet that I want to have the date added to
automatically as an order is entered.
The date just has to be timilar to Microsoft Excels TODAY() function
but only entered once and not changeable after...

I need the code to generate 'todays date' for entry into the sheet,
instead of having the user type the date in.....

is this possible?


---
Message posted from http://www.ExcelForum.com/