E
emily
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
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