|Yes, you need a macro if you want the current date to end up in a cell upon selection.|
However, since macros need very specific instructions written to have them do exactly what you want them to do, we would need something more specific than "just different multiple cells". Which cells?
In addition, you asked for the current date in your first post, but for the current date/time in your second post.
Which is it?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.