XLL+ Class Library (7.0)

Function Wizard Dialog

XLL+ Function Wizard

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.

Name

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.

Return type

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

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.

Description

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.

Tabs

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.

See Also

Summary of Commands | User Guide: Function Wizard