In This Topic
Marks this external variable as volatile. A volatile external variable must be recalculated whenever calculation occurs in any cells on the worksheet. A nonvolatile external variable is recalculated only when the input variables change.
Syntax
'Declaration
Public Sub Volatile( _
ByVal As Boolean _
)
'Usage
Dim instance As ExternalVariable
Dim volatile As Boolean
instance.Volatile(volatile)
public void Volatile(
bool
)
Parameters
- volatile
- if set to
true
this external variable is marked as volatile; otherwise, false
.
See Also