How to make the Today() function static

  • Thread starter Thread starter JC Home
  • Start date Start date
J

JC Home

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,

Apart from mis-spelling your name (sorry!), I forgot to mention that this
code, if you choose to use it, should go into the applicable sheet module.

To get to this, right-click the sheet tab, and select the View option. This
will open the sheet code module, so then paste the code I gave into the code
pane.

Also, if you don't want the time, just use
Target.Offset(0, 1).Value = Format(Date, "dd mmm yyyy")
 
-----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
Click to expand...
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
 
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
Click to expand...

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.
 
Back
Top