XLL+ Class Library

Define the function

The next step is to use the XLL+ Function Wizard to generate the code for the Excel add-in function NORMSDIST2().

Select a source file

Make sure that Developer Studio is open and that Tutorial1 is the active project. Open or activate the file Tutorial1.cpp.

Invoke the Function Wizard

In Developer Studio, using the XLL+ Toolbar, click on the New Function tool. (In Visual Studio .NET or Visual Studio 2005, use the New XLL+ Function item on the Tools menu.) This will start the Function Wizard.

Enter function details

In the Add New Function dialog, fill in the name, category and description of the function as follows:

Name:NORMSDIST2
Category:Statistical
Description:Returns the standard normal cumulative distribution function (has a mean of zero and a standard deviation of one)

What do these fields mean?

Name The name you enter here will be used as the name of the function visible in Excel and also as the name of the C++ function that implements the add-in function.
Category When the function appears in Excel's Formula Wizard, it will appear under the category you enter here.
Description This description will appear in Excel's Formula Wizard. It will also be inserted into your C++ code as part of the function's header comment.

After you click on OK, the main Function Wizard dialog will appear, so that you can enter the other details of the new add-in function.

Next: Add an argument >>