Solved

Excel VBA: Finding currently selected series

Posted on 2012-04-13
1
220 Views
Last Modified: 2012-04-13
I want to write code that will effect the current selected series on a line graph in Excel.

What VBA code would I need that would display the currently selected series number, when a user presses a button.

i.e. if a user has "Series 1" selected on the graph, then a messagebox will appear saying "you have Series 1 selected"

i.e. if user has "Series 2" selected, then a messagebox will appear saying "you have Series 2 selected"
0
Comment
Question by:ouestque
1 Comment
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 500 total points
ID: 37842591
MsgBox Selection.Name
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question