Syntax

expression.AfterRefresh(Success)

expression A variable that represents a QueryTable object.

Parameters

Name Required/Optional Data Type Description
Success Required Boolean True if the query was completed successfully.

Return Value
Nothing

Example

This example uses the Success argument to determine which section of code to run.

Visual Basic for Applications 
Private Sub QueryTable_AfterRefresh(Success As Boolean) If Success ' Query completed successfully Else ' Query failed or was cancelled End If End Sub
after after refresh After Refresh Event AfterRefresh afterrefresh event Event after query is completed or cancelled?

See also: