vincehardwick
New Member
- Joined
- Feb 4, 2021
- Messages
- 20
- Office Version
- 365
- Platform
- Windows
Hi all,
I'm trying to work out a way to programmatically obtain a list of all the function names that appear in the Excel function wizard's 'Select a function' combobox when you select the 'All' category:
I need this so that instead of having to manually create and maintain a list of their names on a sheet (which is my only backup plan atm, it would just be onerous and prone to human error), it can be automatically kept up-to-date if/when Microsoft add new functions in later versions. This is in relation to a function I'm putting together to offset cell/range references in formulas, I need to be able to strip out all function names from a formula as one of the steps in reducing a formula to only its cell/range references.
I've found that you can launch the Function Wizard dialog from VBA - via either Range.FunctionWizard or Application.Dialogs(xlDialogFunctionWizard).Show - but the list of functions doesn't appear to be exposed via that method. I've also scoured through all the CommandBar objects and their Controls, and although I can find the Insert...Function button or the formula auditing items, again the list of all function names didn't show up.
Any ideas?
Vince
I'm trying to work out a way to programmatically obtain a list of all the function names that appear in the Excel function wizard's 'Select a function' combobox when you select the 'All' category:
I need this so that instead of having to manually create and maintain a list of their names on a sheet (which is my only backup plan atm, it would just be onerous and prone to human error), it can be automatically kept up-to-date if/when Microsoft add new functions in later versions. This is in relation to a function I'm putting together to offset cell/range references in formulas, I need to be able to strip out all function names from a formula as one of the steps in reducing a formula to only its cell/range references.
I've found that you can launch the Function Wizard dialog from VBA - via either Range.FunctionWizard or Application.Dialogs(xlDialogFunctionWizard).Show - but the list of functions doesn't appear to be exposed via that method. I've also scoured through all the CommandBar objects and their Controls, and although I can find the Insert...Function button or the formula auditing items, again the list of all function names didn't show up.
Any ideas?
Vince