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
and it's helper class CXlWizExUIArgumentListCreator.
The XLL+ Function Wizard adds code to create a
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.|