View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike Archer Mike Archer is offline
external usenet poster
 
Posts: 52
Default SeriesCollection object

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