View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default SeriesCollection object

Is that for a chart-sheet or embedded chart. If the latter, do you want to
trap the selection event of just one chart or all charts on a sheet or all
in a workbook.

Regards,
Peter T


"Mike Archer" wrote in message
...
Hello. Is there a way to get the name or index of a series collection
that
has been clicked?
Something like:
MsgBox ActiveChart.SeriesCollection.Selected.Name
or
MsgBox ActiveChart.SeriesCollection.Selected.Index

Of course, those examples don't work.

Thanks,
Mike