how to enter the date automatically?
 

How to enter the date automatically. Once I open the file i want it to have
the have the current date. I know it involves using the date command but not
sure how.

Thanks for the help

Private Sub Workbook_Open()
Worksheets("Sheet1").Range("A1").Value = Format(Date, "dd mmm yyyy")
End Sub

'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code



--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jahcureus" wrote in message
...
How to enter the date automatically. Once I open the file i want it to
have
the have the current date. I know it involves using the date command but
not
sure how.

Thanks for the help

Type in =Now in appropriate cell. It will display date and time. To change
format just show date - Format,Cells and click Number tab and select format
you want.

Hope that helps.

"Jahcureus" wrote:

How to enter the date automatically. Once I open the file i want it to have
the have the current date. I know it involves using the date command but not
sure how.

Thanks for the help

=TODAY()

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Jahcureus" wrote in message
...
How to enter the date automatically. Once I open the file i want it to
have
the have the current date. I know it involves using the date command but
not
sure how.

Thanks for the help

Thanks alot guys for the help.
Have a good day.
Much love
Bless

"IrishAnne" wrote:

Type in =Now in appropriate cell. It will display date and time. To change
format just show date - Format,Cells and click Number tab and select format
you want.

Hope that helps.

"Jahcureus" wrote:

How to enter the date automatically. Once I open the file i want it to have
the have the current date. I know it involves using the date command but not
sure how.

Thanks for the help