Fill in the Date & Time automatically.

Dear all:

I have a worksheet which contains a column for the CURRENT day and time. What I would like to do is to have Excel automatically fill in the cell with the NOW() value upon selection of the cell. And I would like to confine this trigger to the entire A column only.

Would some body be kind enough to tell me how to do that, with or without Macro or VBA. A small sub is needed I believe?

Your help will be greatly greatly appreciated.

Best regards
Sentry11

Moved to Office Development