CB.GetDataAnalysisOption

This function returns specified settings made by CB.DataAnalysisND or the Data Analysis tool.

Table 104. CB.GetDataAnalysisOption Returned Data Type

Returned Value	Returned Data Type
The specified Data Analysis settings	Variant

CB.GetDataAnalysisOption has one parameter, Index, which is a required integer. See Table 105 for details.

Table 105. CB.GetDataAnalysisOption Index Parameter — Required, Integer

Named Constant Value	VBA Data Type	Index Value	Description
cbDataAnalysisSelectData	Integer	2	Returns a string with the address of the target forecast in the format: '[workbook]sheet'!$A$1
cbDataAnalysisDataOrientation	Integer	3	Returns one of two possible values for the data orientation: cbDataAnalysisDataInRows [1] cbDataAnalysisDataInColumns [2]
cbDataAnalysisSelectHeaders	Integer	4	Returns a boolean value to indicate if column header text is in the selection (True)
cbDataAnalysisSelectLabels	Integer	5	Returns a boolean value to indicate if row label text is in the selection (True)
cbDataAnalysisSelectLSL	Integer	6	Returns the range of values selected as forecast LSLs (lower specification limit) for process capability analysis. The range is a string in the format: '[workbook]sheet'!$A$1
cbDataAnalysisSelectUSL	Integer	7	Returns the range of values selected as forecast USLs (upper specification limit) for process capability analysis. The range is a string in the format: '[workbook]sheet'!$A$1
cbDataAnalysisSelectTarget	Integer	8	Returns the range of values selected as forecast Targets for process capability analysis. The range is a string in the format: '[workbook]sheet'!$A$1
cbDataAnalysisAutoOpenCharts	Integer	9	Returns a boolean value to indicate whether to open forecast charts automatically when the data analysis runs (True)
cbDataAnalysisSetViewType	Integer	10	If charts are shown, returns cbChtChartType constants from CB.ChartPrefsND to indicate which chart view appears. See Table 24 for returned constants.
cbDataAnalysisFitToDistribution	Integer	11	Returns a boolean value to indicate whether forecast charts should be fitted to a distribution (True)
cbDataAnalysisRankingMethod	Integer	12	Returns the ranking method for distribution fitting. See Table 78 for constants
cbDataAnalysisGenerateCorrelationMatrix	Integer	13	Returns a boolean value to indicate whether rank correlations between forecast charts should be displayed in a matrix (True)
cbDataAnalysisRunOnAllModels	Integer	14	Returns a boolean value to indicate whether a simulation is run on all open workbooks at the same time the selected data is analyzed (True)
cbDataAnalysisNumberOfSeries	Integer	15	Returns an integer value equal to the number of currently selected data series
cbDataAnalysisNumberOfPoints	Integer	16	Returns an integer value equal to the number of points in each data series