expression.DisplayFunctionToolTips
expression Required. An expression that returns one of the objects in the Applies To list.
Example
In this example, Microsoft Excel notifies the user the status of displaying function Tool Tips.
Sub CheckToolTip()
' Notify the user of the ability to display function ToolTips.
If Application.DisplayFunctionToolTips = True Then
MsgBox "The ability to display function ToolTips is on."
Else
MsgBox "The ability to display function ToolTips is off."
End If
End Sub