98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - Auto Insert Date into a Cell
vba courses london - Auto Insert Date into a Cell
Resolved · Low Priority · Version Standard
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
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 tip:Display Text In a Msgbox On Multiple LinesWhen displaying text in a MsgBox you may need to show it over multiple lines. To do this use: |
