enter todays date

[Guest]

i need a macro that enters todays date into whatever cell is selected.
i tried a formula but it updates everyday. so i need it to stay on the date
entered

thank you

 

[Paul B]

choice, here is on way

Sub todays_date()
ActiveCell = Date
End Sub

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **

 

[Gord Dibben]

choice

Are you sure you want a date entered into "whatever cell is selected"? This
could lead to a lotta cells with a date entered.

This would require Event code and may not be what you desire.

To enter a static date into a cell you can use CRTL + ;(semi-colon)

Macro to enter a date in a cell when you run the macro via button or shortcut
key combo.

Sub NOWDATE()
ActiveCell.Value = Format(Date, "dd-mmm-yy")
End Sub


Gord Dibben Excel MVP