This function changes attributes for an assumption without redefining the assumption using CB.DefineAssumND.
Before you call this function, the assumption must exist.
Table 168. CB.SetAssum Returned Data Type
Returned Value | Returned Data Type |
|---|
Whether the function was successful | Variant |
Table 169. CB.SetAssum Parameters
Parameter | VBA Data Type | Value | Description |
|---|
AssumReference | Variant | In a macro: Range("B3") | Points to the assumption cell with the data to change |
Index | Integer | See Table 170 | Changes the assumption name and truncation points according to Value. |
Value | Variant | See Table 171 | Works with Index to specify an assumption name and truncation values |
Table 170, following, describes the Index parameter.
Table 170. CB.SetAssum Index Parameter Values — Required, Integer
Named Constant Value | Index Value | Description |
|---|
cbAsmName | 1 | Changes the assumption name according to Value |
cbAsmLowCutOff | 6 | Changes the lower truncation point according to Value |
cbAsmHighCutOff | 7 | Changes the higher truncation point according to Value |
Table 171, following, describes the Value parameter.
Table 171. CB.SetAssum Value Parameter Values — Required, Variant
Used With Specified Values of Index | Value | Description |
|---|
For Index = cbAsmName [1]: String | Assumption name, in quotes ("") | Specifies the new assumption name |
For Index = cbAsmLowCutOff [6]: Double | Any number | Sets the new lower truncation point |
For Index = cbAsmHighCutOff [7]: Double | Any number | Sets the new upper truncation point |