Built-in functions - overview through VBA?

Rijnsent

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

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,785
Office Version
  1. 2010
Platform
  1. Windows
I think the necessary attribute to do that is reflection, which VBA does not support.
 

Watch MrExcel Video

Forum statistics

Threads
1,130,073
Messages
5,639,920
Members
417,119
Latest member
adityaj252

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top