XLL+ Class Library

List of Walkthroughs

Walkthroughs give step-by-step instructions for common scenarios, which makes them a good place to start learning about the product or a particular feature area.

Arrays

Adding a vector argument
Describes how to add a one-dimensional array argument (a vector) to an add-in function.
Returning a vector result
Describes how to return a one-dimensional array argument (a vector) from an add-in function.
Adding a matrix argument
Describes how to add a two-dimensional array argument (a matrix) to an add-in function.
Returning a matrix result
Describes how to return a two-dimensional array argument (a matrix) from an add-in function.
Installing your own matrix class
Describes how to install your own matrix class, and use it instead of the classes supplied with XLL+.

Function Wizard Features

Grouping multiple arguments into a single Excel range
Describes how to use the Function Wizard to create an add-in function that accepts and decodes multiple arguments in a single range, so as to reduce the total number of arguments to a function.

Using Excel features

Calling an Excel built-in function from your add-in
Describes how to call an Excel built-in function from your own add-in function, and how to inspect the results.
Creating and populating a worksheet from your add-in
Describes how to create a new worksheet from your add-in function, and how to populate its cells.

Graphical User Interface

Adding your own menus
Describes how to add your own menus to Excel's application menu-bar, and how to link the menu items to add-in functions.
Displaying native Excel dialogs
Describes how to display a native dialog from within your add-in function. Shows how to use the CDialog layout capabilities to simplify the design of native Excel add-ins.