I have an excel xla add-in called EconLibrary.xla, in it there is
single module which stores all my code, it's called 'AddInCode'.
AddInCode contains several functions, most of which are functions t
use within cells in excel. I need some VBA code that will give me
list (an array would be nice) of all the functions currently containe
in the module. A list like the one in the drop down box is what I'
after. I imagine there is a built in function for getting this array
but I can't find it. Please help! Thank you.

IE:

Dim funclist() As Variant
funclist
Workbooks("EconLibrary.xla").VBProjects.Modules("A ddInCode").Functions.List

obviously thats garbage, but you get the idea

+-------------------------------------------------------------------
|Filename: vbaquestion.JPG
|Download: http://www.excelforum.com/attachment.php?postid=5070
+-------------------------------------------------------------------

--
CalDud
-----------------------------------------------------------------------
CalDude's Profile: http://www.excelforum.com/member.php...fo&userid=3662
View this thread: http://www.excelforum.com/showthread.php?threadid=56375