Identify selected chart
 

Hello Group,

I have two charts on Sheet1.
One of them is selected.

How do I determine which has been selected ? VBA

Thanks,

Michael Singmin

Identify selected chart
 

Hi Michael

you can use the
activechart.name
syntax

e.g.
MsgBox ActiveChart.Name

Cheers
JulieD


"Michael Singmin" wrote in message
...
Hello Group,

I have two charts on Sheet1.
One of them is selected.

How do I determine which has been selected ? VBA

Thanks,

Michael Singmin

Identify selected chart
 

msgbox activechart.name

--
Don Guillett
SalesAid Software

"Michael Singmin" wrote in message
...
Hello Group,

I have two charts on Sheet1.
One of them is selected.

How do I determine which has been selected ? VBA

Thanks,

Michael Singmin

Identify selected chart
 

Hi,

If you don't want to deal with the sheetname information returned by
Activechart.Name then you can use

Msgbox Activechart.parent.name

Cheers
Andy

Michael Singmin wrote:
Hello Group,

I have two charts on Sheet1.
One of them is selected.

How do I determine which has been selected ? VBA

Thanks,

Michael Singmin

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info