Macro to enter current date into active cell

[clumzyfish]

It seems fairly easy, but I can't figure it out. Is it possible to set up a macro to enter today's date into the currently selected cell when ran?

Thanks

 

[schielrn]

Like this:

sub addDate()
activecell.value = Date
end sub

You can also press control+semicolon and it inputs the current date using a shortcut key.

Hope that helps.

 

[clumzyfish]

wow, thought I tried that already. thanks!