The XLL+ Function Wizard lets you edit all aspects of an add-in function, including its name, description and signature.
At the top of the window is a menu and a toolbar, containing all the commands that may be used. See Summary of Commands for a list.
The upper half of the window contains four important fields that define and describe the function. They are listed below, with a link to the property that each field contains.
This is the name of the function as it will appear in Excel. It may not be localized, i.e. it must be the same in all user languages. It should be unique within an add-in project.
See also Function.ExportedName.
The type of value that will be returned to Excel.
The value will always be CXlOper for functions which return a variable type, or return arrays, or may fail. The default value for ReturnType is CXlOper.
See also Function.ReturnType.
Category in which the function will appear within the Excel Formula Wizard. You can use one of Excel's built-in categories, or you can define your own.
The category name can be localized, so that it will appear in the
language of the user. Localized categories should be in the form
#123 where the number refers to a string in the resource file.
See Types of string - Category
in the User Guide for more information on localizing categories.
See also Function.Category.
The description of a function, as it will appear in Excel's Formula Wizard.
The description can be localized, so that it will appear in the
language of the user. Localized descriptions should be in the form
#123 where the number refers to a string in the resource file.
See Types of string - Help text
in the User Guide for more information on localizing function descriptions.
See also Function.Description.
There are several tabs in the lower half of the window, which let you edit and review various aspects of the add-in function.
| Tab | Contents |
|---|---|
| Arguments | The arguments grid lets you edit all the function's argument in a grid form. |
| Features | The features page lets you control the behavior and availability of the add-in function. |
| Extensions | This tab lists any of the function extensions that are currently available. You can switch them on and off for this add-in function, and set any parameters. |
| Details | The details tab displays all aspects of the add-in function in a tree/grid view. You can use it to drill-down to any level of detail about the function itself and all of its arguments. |
| Preview | A preview of the function, as it will appear in C++ code, is displayed in the preview tab |
| Error | The errors tab displays a list of all the errors and warnings detected by the wizard in the current add-in function. |