XLL+ Class Library (7.0)

Function Wizard - Features Tab

The Features Tab contains two groups of controls:

Behavior

The Behavior panel contains a list of switches which control the code that is generated for the function. The more commonly used switches are described below.

Cache results

If this item is checked, then the function's result will be stored in an application-level cache. Each time the function is called, the cache is searched for an identical set of inputs. If they are found, then the result is returned from the cache and the implementation function is not called. This can result in a considerable performance improvement.

See also the Function.CacheResults property.

Create asynchronous version

If this item is checked, then an additional add-in function will be created which runs the core function asynchronously, in a worker thread. The function will be have the same name as the core function, plus the suffix "Async". See Asynchronous functions in the User Guide.

See also the Function.CreateAsyncVersion property.

Do not call in Formula Wizard

If this item is checked, then the function will return #VALUE! when it is called from the Excel Formula Wizard.

See also Excel Formula Wizard: Automating the code in the User Guide.

Thread safe

If this item is checked, then the function will be registered as a thread-safe function, which means that Excel can call the function on multiple threads simultaneously. See Ensuring global data is thread-safe in the User Guide.

Note that this property is ignored in Excel 2003 and below.

See also the Function.IsThreadSafe property.

Volatile

If this item is checked, then the function will be registered as a volatile function, which means that Excel will recalculate any cell containing the function whenever any cell in the same sheet is recalculated. See Volatile functions in the User Guide.

See also the Function.IsVolatile property.

Availability

This group of controls specifies when and where the add-in function will be available.

Worksheet Function can be called from worksheet cells, and will be listed in the Excel Formula Wizard.
Macro Function can be called from macros or as a command. It may not be called from worksheet cells. It will not be listed in the Excel Formula Wizard.
Hidden Function can be called from worksheets cells or from macros or as a command. It will not be listed in the Excel Formula Wizard.

See also the Function.Availability property.

See Also

Function Wizard Dialog | Summary of Commands