When debugging/updating VBA code I like to add comment lines to time stamp
when the change was made
eg

' updated 14/8/2003 1.46pm

I'd like to automate this eg by having a custom tool which will insert the
whole comment line with one click (with the current date/time of course).
This is easily done in other programming IDE's eg Compaq Fortran Developer
Studio, where you can simply record a macro withing the IDE and make it
available whenever you are writing code.
I cannot find any way of doing this in VBA under Excel 9.0 aka Excel 2000.
Can anyone help?
Thanks

--
james

try

www.mztools.com

a very usefull (freeware) addin for the VBE that has all the things you
want


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


emily wrote:

When debugging/updating VBA code I like to add comment lines to time
stamp when the change was made
eg

' updated 14/8/2003 1.46pm

I'd like to automate this eg by having a custom tool which will insert
the whole comment line with one click (with the current date/time of
course). This is easily done in other programming IDE's eg Compaq
Fortran Developer Studio, where you can simply record a macro withing
the IDE and make it available whenever you are writing code.
I cannot find any way of doing this in VBA under Excel 9.0 aka Excel
2000. Can anyone help?
Thanks