CB.DefineAltParms Example 2

This example defines the assumption in cell B6 as a normal distribution using the 10th and 90th percentiles. The 10th percentile is 10, the 90th percentile is 12, and cbParmNone is a placeholder in the argument list.

Range("B6").Select
Value1 = CB.DefineAltParms(cbDfaNormal,cbParmPercentile + 10, _
   cbParmPercentile + 90, cbParmNone)
CB.DefineAssumND Value1, 10, 12

Note:

If you use the numeric value of the index instead of the constant name for cbParmPercentile, as in Example 3, you must use the sample syntax, 0 +<percentile>, so that the function can identify the parameter by the numeric value.