Application.Volatile Method (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Marks a user-defined function as volatile. A volatile function must be recalculated whenever calculation occurs in any cells on the worksheet. A nonvolatile function is recalculated only when the input variables change. This method has no effect if it's not inside a user-defined function used to calculate a worksheet cell.

expression .Volatile(Volatile)

expression A variable that represents an Application object.

Parameters

Name

Required/Optional

Data Type

Description

Volatile

Optional

Variant

True to mark the function as volatile. False to mark the function as nonvolatile. The default value is True

This example marks the user-defined function "My_Func" as volatile. The function will be recalculated when any cell in any workbook in the application window changes value. Recalculation of the function is not restricted to changes or calculation cycles in the worksheet for which this function applies. Therefore, use it moderately to avoid calculation lag.

Function My_Func() 
 Application.Volatile 
 ' 
 ' Remainder of the function 
 "> 
End Function
Show: