is object chart?

[Mark]

Hi,
How recognize (in VBA) is activeobject chart?

Best regards
Mark

 

[Jan Karel Pieterse]

Hi,

msgbox Typename(Selection)

Or

msgbox Typename(Selection.Parent)

Should give you some pointers.

Candidates:

ChartArea
ChartObject
Chart

Regards,

Jan Karel Pieterse
Excel TA/MVP

 

[Jon Peltier]

Mark -

Try this:

If Not ActiveChart is Nothing Then
'' Selected object is a chart.
End If

- Jon