CB.GetDecisionTableOption

This function returns specified settings made by CB.DecisionTableND or the Decision Table tool.

Table 106. CB.GetDecisionTableOption Returned Data Type

Returned Value	Returned Data Type
The specified Decision Table settings	Variant

Table 107. CB.GetDecisionTableOption Parameters

Parameter	Required?	VBA Data Type	Table
Index	Required	Integer	Table 108
Index2	Optional	Integer	Table 109

Table 108. CB.GetDecisionTableOption Index Parameter – Required, Integer

Named Constant Value	Index Value	Description
cbDecGetTarget	1	Returns a string with the address of the target forecast in the format: '[workbook]sheet'!$A$1
cbDecGetDecVar	2	Returns a string with the address of the selected decision variable in the format: '[workbook]sheet'!$A$1 Must be used with Index2 (cbDecVar1 or cbDecVar2) to indicate which decision variable’s address to return.
cbDecSimOption	3	Used with Index2 to return the number of test values for the specified decision variable or the maximum number of trials for the simulation
cbDecForeOption	4	Returns the current forecast chart display setting: 1 = Show Forecasts As Defined (set with cbDecShowDefinedFore) 2 = Show Only Target Forecast (set with cbDecShowTargetFore) 3 = Hide All Forecasts (set with cbDecHideFore)

Table 109. CB.GetDecisionTableOption Index2 Parameter – Optional, Integer

Named Constant Value	Index Value	Description
cbDecVar1	1	Used with cbDecGetDecVar to return the address of the first selected decision variable in the format: '[workbook]sheet'!$A$1
cbDecVar2	2	Used with cbDecGetDecVar to return the address of the second selected decision variable in the format: '[workbook]sheet'!$A$1
cbDecNumValuesVar1	1	Used with cbDecSimOption to return the number of test values to use for the first selected decision variable
cbDecNumValuesVar2	2	Used with cbDecSimOption to return the number of test values to use for the second selected decision variable
cbDecSimTrials	3	Used with cbDecSimOption to return the maximum number of trials for each simulation