Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now
Course Of The Month
6 days, 4 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
What control would I use to get chart selection?
Posted on 2011-03-04
I'm writing an addin, where the user has to select a chart, and then select a range (two different entries). What control would I use on a userform to enable the user to select a chart (and get that value - e.g., "Chart 1" on a particular sheet - or for that matter, an active chart on a chart sheet?
Thanks!
Dave
Thanks!
Dave
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
6-
2
8 Comments
You can pop up a message telling the user to select a chart and after that you can use the selection object to interact with the chart?
Sid
Sid
Possibly - since this is top of mind for you, how would I test the selection to ensure it was a chart they had selected?
Dave
Dave
Example
Sid
'~~> Checks if selection is a valid chart
Sub Sample()
On Error GoTo Err
If TypeName(Charts(Selection.Parent.Name)) = "Chart" Then _
Debug.Print "You have selected a Chart Sheet"
Err:
If TypeName(Selection) = "ChartArea" Then
Debug.Print "You have selected a Chart in a Sheet"
Else
Debug.Print "Invalid Selection"
End If
End Sub
Sid
And to check for the Chart Type.
Sid
'~~> Checks if selection is a valid chart
'~~> Also Check for the Chart Type
Sub Sample()
On Error GoTo Err
If TypeName(Charts(Selection.Parent.Name)) = "Chart" Then
On Error GoTo 0
Debug.Print "You have selected a Chart Sheet"
Debug.Print "Chart Type :" & ActiveChart.ChartType
End If
Exit Sub
Err:
If TypeName(Selection) = "ChartArea" Then
Debug.Print "You have selected a Chart in a Sheet"
Debug.Print "Chart Type :" & ActiveChart.ChartType
Else
Debug.Print "Invalid Selection"
End If
End Sub
Sid
Featured Post
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
Suggested Courses
Course of the Month6 days, 4 hours left to enroll
705 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.