Rijnsent
Well-known Member
- Joined
- Oct 17, 2005
- Messages
- 1,392
- Office Version
- 365
- Platform
- Windows
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?
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?