What control would I use to get chart selection?

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

Microsoft Excel

Last Comment

dlmille

8/22/2022 - Mon

SiddharthRout

3/4/2011

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

SiddharthRout

3/4/2011

For selecting different Range, you can use the RefEdit Control.

Sid

dlmille

3/4/2011

ASKER

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

Your help has saved me hundreds of hours of internet surfing.

fblack61

SiddharthRout

3/4/2011

You can use the TypeName(Selection)

Sid

SiddharthRout

3/4/2011

Example

'~~> 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