An argument which (i) has a Value List defined and (ii) has the setting Show list in Formula Wizard set will present a drop-down combo box in the Excel Formula Wizard.
The use of drop-down lists in the extended UI is managed by the classes
in xlwizexui.h, in particular
CXlWizExUIListProvider,
and it's helper class CXlWizExUIArgumentListCreator.
The XLL+ Function Wizard adds code to create a CXlWizExUIListProvider
for each argument that supports a drop-down list.
The topics below contain more details about the use of Value Lists.
| Value Lists | Introduction to value lists. |
| A value list example | A walkthrough showing how to add a value list to an add-in function. |
| Editing value lists | Tips for working with value lists more effectively. |
| Dynamic lists | How to change the contents of a value list at run-time. |
| Changing the keyboard behavior | How to change which keys are assigned to actions in the Formula Wizard. |