CB.GetDecisionTableOption Example

The following example returns information for the Decision Table definition created in CB.DecisionTableND Example and stores it in cells M6 through M12.

'Gets the address of the target forecast
Range("M6").Value = CB.GetDecisionTableOption(cbDecGetTarget)
'Gets the address of the first and second selected decision variables
Range("M7").Value = CB.GetDecisionTableOption(cbDecGetDecVar, cbDecVar1)
Range("M8").Value = CB.GetDecisionTableOption(cbDecGetDecVar, cbDecVar2)
'Gets the number of test values for the first and second decision variables
Range("M9").Value = CB.GetDecisionTableOption(cbDecSimOption, _
   cbDecNumValuesVar1)
Range("M10").Value = CB.GetDecisionTableOption(cbDecSimOption, _
   cbDecNumValuesVar2)
'Gets the maximum number of trials per simulation
Range("M11").Value = CB.GetDecisionTableOption(cbDecSimOption, _
   cbDecSimTrials)
'Returns the forecast chart window display setting
Range("M12").Value = CB.GetDecisionTableOption(cbDecForeOption)