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

-----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

On Thu, 24 Jul 2003 15:38:03 -0400, "JC Home" wrote:

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

Record a macro where you type =now()into any blank cell, copy,
paste-special/value. Anywhere you want to insert a static date, select that
cell and run the macro. Assigning that mcro to a key combination makes it
really easy to use.