Function List

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

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.

"ExcelMonkey" wrote:

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