VBA: ActiveFunctionsCount

Visual Basic for Applications macros are not supported by Excel Online.

Purpose

Provides a means to check if Velixo is currently running background functions.

See Introduction to Velixo's VBA functions for general usage information.

Syntax

CODE

objVelixo.ActiveFunctionsCount

objVelixo- a variable that represents an instance of the Velixo VBA functions class.

Example

Use ActiveFunctionsCount to provide completion feedback after a background RefreshFull.

CODE

Dim velixoObj As Velixo_Reports.VBA
Set velixoObj = CreateObject("Velixo.Reports.Vba") velixoObj.RefreshFull True

Do While velixoObj.ActiveFunctionsCount > 0 Or Application.CalculationState = xlCalculating 
    DoEvents
    Sleep 500 'Sleep needs to be imported using declare statement
Loop

MsgBox "Refresh Completed!"