Check whether a chart is selected by the user or not using VBA

Hi,

I need a function which return the chart name which is selected by the user, without assigining macro to the chart.
By clicking a button i need the activated chart name. so that mean The function will be assigned to this button.

Thanx in Advance.

Hi Mohan,

Welcome to ExcelFox !!!

may be..

Code:

---

Dim chtSelected As Chart
   
    On Error Resume Next
    Set chtSelected = ActiveChart
    On Error GoTo 0
    If chtSelected Is Nothing Then
        MsgBox "No chart selected", vbInformation
    Else
        MsgBox chtSelected.Name
    End If

---

Thanx Admin for Ur Quick Reply.:o

Working!!!!!!!!!!!!.
:o