/
Visual Basic Applications (VBA) Refresh

Visual Basic Applications (VBA) Refresh

Using the following syntax, Barchart for Excel users can invoke a refresh via VBA.

Application.Run "BE_RefreshAll"

You can trigger a data refresh by pasting the VBA code into the Worksheet. Double-click the desired Sheet object in the VBA Project Pane to open the text editor (blank white sheet) within the Visual Basic Editor.

Example of code below:

Sub BE_Refresh()
Application.Run "BE_RefreshAll"
End Sub

Run the macros from the Macros button in the Developer tab or assign a macro to a button from the Insert section in the Developer tab.

 

Related content

Syntax and Functions
Syntax and Functions
More like this
Fields
Read with this
Refresh
More like this
Visual Basic Applications (VBA) Refresh
Visual Basic Applications (VBA) Refresh
More like this
Refresh
More like this
Barchart for Excel User Guide
Barchart for Excel User Guide
More like this