The next step is to use the XLL+ Function Wizard to generate the code for the Excel add-in function NORMSDIST2().
Make sure that Developer Studio is open and that Tutorial1 is the active project. Open or activate the file Tutorial1.cpp.
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.
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.