P
pinkfloydfan
Hi there
Having written a large number of UDFs and Classes with their
associated Properties & Methods I was wondering if rather than
manually typing them all into a spreadsheet is there a way I can get
VBA to do this automatically for me?
So for example, the code would search through the current open
projects, note the various functions & subs in Modules and Class
Modules and list them all on a new sheet.
I'm sure this would be quite useful for a lot of people.
Many Thanks
Lloyd
Having written a large number of UDFs and Classes with their
associated Properties & Methods I was wondering if rather than
manually typing them all into a spreadsheet is there a way I can get
VBA to do this automatically for me?
So for example, the code would search through the current open
projects, note the various functions & subs in Modules and Class
Modules and list them all on a new sheet.
I'm sure this would be quite useful for a lot of people.
Many Thanks
Lloyd