Identify selected chart

M

Michael Singmin

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
 
J

JulieD

Hi Michael

you can use the
activechart.name
syntax

e.g.
MsgBox ActiveChart.Name

Cheers
JulieD
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Determine the USB drive 9
Names of Shapes 5
Format Date in Chart Title 2
Multiple selected charts 1
What is Selected? 2
Chart Datalabels.Position 4
Paste Excel chart in Powerpoint - how to "send to back" the pasted chart 1
What is the purpose of a Macro Sheet ? 1

Top