Selected series in chart
 

Are there any way to determine which series are selected - if any - in the
seriescollection for a chart ?

Selected series in chart
 

If you don't have any duplicate names:

Dim srs As Series
If TypeName(Selection) = "Series" Then
Set srs = Selection
MsgBox "You've selected the series '" & srs.Name & '"."
End If

- Jon
-------
Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html

Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"ojv" wrote in message
...
Are there any way to determine which series are selected - if any - in the
seriescollection for a chart ?

Selected series in chart
 

If you don't have any duplicate names:

Dim srs As Series
If TypeName(Selection) = "Series" Then
Set srs = Selection
MsgBox "You've selected the series '" & srs.Name & '"."
End If

- Jon
-------
Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html

Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"ojv" wrote in message
...
Are there any way to determine which series are selected - if any - in the
seriescollection for a chart ?

Selected series in chart
 

Thx.

"Jon Peltier" wrote:

If you don't have any duplicate names:

Dim srs As Series
If TypeName(Selection) = "Series" Then
Set srs = Selection
MsgBox "You've selected the series '" & srs.Name & '"."
End If

- Jon
-------
Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html

Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"ojv" wrote in message
...
Are there any way to determine which series are selected - if any - in the
seriescollection for a chart ?