Function List

[ExcelMonkey]

Is it possible to create a dropdown box in VBA that will
give me the entire Excel Function list. That is, I want
to replicate the list that appears when you choose:

Insert\Funtion\All

ABS
Accrint
ACCRINT
Etc.....

Thanks

 

[Guest]

You can obviously make a dropdown box and put the function names in there -
typing them one by one - but I don't know of any programmatic way to list the
functions. They are not in any collection or even any list of excel globals
that I can find. Perhaps the best option would be to find a list of the
functions in the documentation files, or online, copy and paste to an Excel
range, and use that as the row source... think that would be feasible.