Identify selected chart

  • Thread starter Thread starter Michael Singmin
  • Start date Start date
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
 
Hi Michael

you can use the
activechart.name
syntax

e.g.
MsgBox ActiveChart.Name

Cheers
JulieD
 
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

Format Date in Chart Title 2
Determine the USB drive 9
Chart Datalabels.Position 4
Names of Shapes 5
Disable hide for a column 2
What is the purpose of a Macro Sheet ? 1
What is Selected? 2
Strange behaviour in VBA Help 4

Back
Top