Purpose

Provides a mean to check if Velixo is currently running backgrounds functions.

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

Syntax

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.

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!"
Did this answer your question?