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.