MrExcel Publishing
Your One Stop for Excel Tips & Solutions

I need to insert current day but then stay there

Posted by Adam K. on May 17, 2000 10:31 AM

I have a checking book writing program where the date field automatically get inputed by using the today() function when another field has data.
my problem is that all the dates update to today.
I want it so it plugs in the current date but then keeps that day so i it will stay on the date that i initially plugged in the data.

thanks in advance

Posted by Ivan Moala on May 17, 2000 12:48 PM

You don't say which version of excel you are using.
But if Excel97 + then you could look @ the
Event handlers to accomplish this.
Have a look @ online help in the VBA Editor
Alt + F11 then F1 then Type "Selectionchange"


Posted by Zif on May 18, 2000 4:51 AM


Once you have selcted the cell you want to contain the current date, you can use the following:
ActiveCell.Value = Date

This will put the current system date into the active cell as a value and not as a formula so it won't recalculate to Today() every time you open the workbook.