Took a look in the archives

http://groups.google.com/advanced_gr...ugroup=*excel*

Here's one possibility:

http://groups-beta.google.com/group/...misc/browse_fr
m/thread/65f3a0b5357742cf/670b5910f9729c9a?hl=en#670b5910f9729c9a

In article .com,
wrote:

Hello,

I'm trying to work on a spreed sheet for tracking vendor calls and what
have you. I would like to make it easy for our workers to insert the
current date and time by means of a mouse click. Currently I have used
validation to give them dropdown lists for varying cell data and would
like something kinda like that for the date/time issue. I know of the
=NOW() function but the issue i have with, when wrapped with validation
at least) is that it needs to be recalculated which means they have to
click the drop down box, select the time and then reclick to post the
current date/time.

I'm sure I will need to use a Macro or VBA but I'm pretty green on both
these topics and would like some input on how I might accomplish said
task. It looks as if VBA is more advanced than a regular macro so I
assume VBA is the way to go.


Thanks ahead of time for all your input.

Mattchewie