can the VBIDE have its own macros?

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VB.NET with Excel VBA 3
Excel 2003 - VBA to get a list of Module names in the project 4
problem with "file not found" calling a dll from VBA 6
The VBA IDE will discard changes without warning 6
Opening workbook in its own program 0
Help Needed, May have bitten off more than I can chew 35
Macro with a memory 2
HELP!!! I have written my 1st ever VBA code and need more advice.... 6

Top