Built-in functions - overview through VBA?

[Rijnsent]

Is it possible to show all Excel functions and their properties through VBA? So: a list of all functions, what goes in the function, what is the default help text with each input value, what is the help text with the function, etc. I can find it for UDFs, but am looking for the default built-in ones like IF, VLOOKUP, SUMPRODUCT etc.. Yes, I know there are lists online but I want to get them from Excel itself.

Like:
VLOOKUP - function_category : search - input: lookup_value;in_range; etc. - help text with the VLOOKUP function
HLOOKUP - etc.

I've been looking all over the place, Application.Dialog seems to be a way to go, but can't figure it out.

The goal behind it: I'm writing code to help the user understand bigger formulas better, splitting it into a treeview. Kind of what Productivity and Brand Compliance Add-ins for Excel, PowerPoint & Word | Macabacus and https://www.arixcel.com/ are doing, but seem to be missing some of the elements I need. Can anyone give some pointers?

 

[shg]

I think the necessary attribute to do that is reflection, which VBA does not support.