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/
|