Parameter.RefreshOnChange Property
True if the specified query table is refreshed whenever you change the parameter value of a parameter query. Read/write Boolean.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property RefreshOnChange As Boolean
Get
Set
'Usage
Dim instance As Parameter
Dim value As Boolean
value = instance.RefreshOnChange
instance.RefreshOnChange = value
bool RefreshOnChange { get; set; }
Property Value
Type: System.Boolean
Remarks
You can set this property to True only if you use parameters of type xlRange and if the referenced parameter value is in a single cell. The refresh occurs when you change the value of the cell.