vba courses london - Auto Insert Date into a Cell

The UK's most regular instructor-led training courses.
Training information: vba courses london · Excel london

Resolved · Low Priority · Version Standard

Auto Insert Date into a Cell

Alex has attended:
Project Intro Intermediate course
Excel Advanced course
Excel VBA course

by - delegate Alex [4 posts] (2006 Nov 15 Wed, 08:52) Reply

Is it possible for a cell to be automatically populated with todays date in earlier versions than Excel 2003?

RE: Auto Insert Date into a Cell

by - trainer Garry gold contributer [188 posts] (2006 Nov 15 Wed, 09:22) Reply

this does not sound like a vba code try typing
=TODAY() IN THE CELL

RE: Auto Insert Date into a Cell

by - delegate Alex [4 posts] (2006 Nov 15 Wed, 15:57) Reply

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?

RE: Auto Insert Date into a Cell

by - trainer Carlos gold contributer [479 posts] (2006 Nov 24 Fri, 12:15) Reply

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

· Visual Basic Returns To The Macintosh
· Should You Send Managers To VBA Training?
· Introduction to Visual Basic for Applications
· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?
· Company Roles in Visual Basic Training

Vba tip:

Stop Screen Flickering When Running Code

Running VBA code may cause the screen to flicker as the monitor is the slowest part of the program and cannot keep up with the very fast changes taking place.

To switch off the screen until the program is run enter the following code line:

Application.ScreenUpdating = False

The screen comes on automatically on completion of the program.

View all VBA hints and tips

Rate this page: