Occurs before a ScreenTip is to be displayed.
Private Sub Object_BeforeScreenTip(ByVal TipText As ByRef, ByVal ContextObject As Object)
Object The name of the ChartSpace object that you are trapping this event for.
TipText Set the Value property of this object to the ScreenTip that you want to display. Set the Value property to "" to suppress the ScreenTip.
ContextObject The object in the chart that triggered the ScreenTip.
BeforeScreenTip event as it applies to the PivotTable object.
Occurs before a ScreenTip is to be displayed.
Private Sub Object_BeforeScreenTip(ByVal ScreenTipText As ByRef, ByVal SourceObject As Object)
Object The name of the PivotTable object that you are trapping this event for.
ScreenTip Text Set the Value property of this object to the screen tip that you want to display. Set the Value property to "" to suppress the ScreenTip.
SourceObject The object in the chart that triggered the ScreenTip.
Remarks
Use this event to customize ScreenTips displayed in a chart or PivotTable list.