-----Original Message-----
I would like to have a cell enter the current date when I
make an entry in
another cell, but I would like it to be static. The
today() and now() both
seem to be volatile. I know that I could use cntl ; but
I would like it
to be entered automatically.

Thanks

--
Jeff Ciaccio
Dallas, GA
(W) 770-591-6819 x-274
http://mywpages.comcast.net/ciaccio8515


Jeff,

I assume you are familiar with the vba environment in
Excel. Go ahead and go into the VBA environment (ALT+F11).
Dbl Click the worksheet you want to do this with. Select
Worksheet in the combo box at the top left. Goto the
Worksheet_Change. Do something like the following:

IF Target.Col=X and Target.Row=Y THEN
Target.offset(0,5)=str(Date) 'go over 5 columns and
place date stemp.
END IF

-Paul