Wed 15 Nov 2006, 08:52Delegate Alex said...
Alex has attended:
Project Intro Intermediate course
Excel Advanced course
Excel VBA Intro Intermediate course
Auto Insert Date into a Cell
Is it possible for a cell to be automatically populated with todays date in earlier versions than Excel 2003?
Wed 15 Nov 2006, 09:22Trainer Garry said...
RE: Auto Insert Date into a Cell
this does not sound like a vba code try typing
=TODAY() IN THE CELL
Wed 15 Nov 2006, 15:57Delegate Alex said...
RE: Auto Insert Date into a Cell
Is there any way of using a macro to do this so that the date does not change everytime the file is opened, hence showing the original date of when the macro was run?
Fri 24 Nov 2006, 12:15Trainer Carlos said...
RE: Auto Insert Date into a Cell
Instead of a macro you could click in the cell where the date is to appear and use
Ctrl+Semi Colon(;)
To enter today's date in the cell
