O ojv Jun 4, 2009 #1 Are there any way to determine which series are selected - if any - in the seriescollection for a chart ?
Are there any way to determine which series are selected - if any - in the seriescollection for a chart ?
J Jon Peltier Jun 5, 2009 #2 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-06-ACNJ/AdvExcelConf200906ACNJ.html Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______
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-06-ACNJ/AdvExcelConf200906ACNJ.html Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______
O ojv Jun 5, 2009 #3 Thx. Jon Peltier said: 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-06-ACNJ/AdvExcelConf200906ACNJ.html Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ Click to expand...
Thx. Jon Peltier said: 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-06-ACNJ/AdvExcelConf200906ACNJ.html Jon Peltier, Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ Click to expand...
