ExcelBanter - is object chart?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - is object chart? (https://www.excelbanter.com/excel-programming/278340-object-chart.html)

Mark[_17_]

is object chart?

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

Best regards
Mark

Jan Karel Pieterse

is object chart?

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

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

Best regards
Mark

.

Jon Peltier[_4_]

is object chart?

Mark -

Try this:

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

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

Best regards
Mark

All times are GMT +1. The time now is 01:47 PM.