"Emredrum" wrote:

I would like to be able to double click a cell to insert the date. I know
ctrl + ; will insert it, but is there a way to have the cell read a double
click to do what i want?

That worked perfectly, but of course now i would like to do a little more..

Within this same structure, can i have it so i can assigned a cell range to
reflect a different option when dlciked. IE, Double click B6 to insert date,
then B7 To insert the time, then c6 for date, c7 for time. the cell ranges
can be specified.

So im looking for these double click options also using a cell ref for their
decisions. Yes i am lasy.

Thanks in advance.