These lines of example code return the options set in CB.ScenarioAnalysisND Example. In actual function code, the return values should be assigned to variables so they can be displayed or written to a worksheet.
' The following code returns the target forecast cell, B1 CB.GetScenarioAnalysisOption cbSceChooseTarget ' Returns cbSceSelectPercentiles ' Percentiles are used for analysis CB.GetScenarioAnalysisOption cbSceRangeForecastResults ' Returns the minimum value of the percentile range (50th percentile) CB.GetScenarioAnalysisOption cbSceSelectPercentiles, cbSceMinValue ' Returns the maximum value of the percentile range (75th percentile) CB.GetScenarioAnalysisOption cbSceSelectPercentiles, cbSceMaxValue ' Returns the Options setting, cbSceShowTargetFore CB.GetScenarioAnalysisOption cbSceForeOption ' Returns the number of trials to run, 500 CB.GetScenarioAnalysisOption cbSceSimTrials ' Returns whether to include only the target in the results, False CB.GetScenarioAnalysisOption cbSceIncludeNonTargetFore