Thread: Selected series in chart
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier Jon Peltier is offline
external usenet poster
  
Posts: 6,582
Default 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 ?


Reply With QuoteReply With Quote