/
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.
, multiple selections available,
Related content
Syntax and Functions
Syntax and Functions
More like this
Fields
Fields
Read with this
Refresh
Refresh
More like this
Visual Basic Applications (VBA) Refresh
Visual Basic Applications (VBA) Refresh
More like this
Refresh
Refresh
More like this
Barchart for Excel User Guide
Barchart for Excel User Guide
More like this