Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - Auto Insert Date into a Cell
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
vba courses london - Auto Insert Date into a Cell
Resolved · Low Priority · Version Standard
Reply 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?
For upcoming training course dates see: Pricing & availability
RE: Auto Insert Date into a Cell
this does not sound like a vba code try typing
=TODAY() IN THE CELL
Reply 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?
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
|