Thread: Chart Naming

I am looking to have a chart name update as a function in VBA...

Code:

 Private Sub Chart_Activate()
    
    TempName = Worksheets(1).Cells(8, 15).Value

    With ActiveChart
            .HasTitle = True
            .ChartTitle.Characters.Text = TempName
    End With

End Sub

This above code works if a specified cell reference value is assigned to TempName. However, I am using a validation drop down list that will sort the sheet, given the a list criteria. Is there any way to extract the value of the sorted criteria from that drop down list and use that as the TempName value? Any help is greatly appreciated.

Please use CODE tags rather than Italic.

You need to supply more information about how you would know where the title was. Once you can explain that we should be able to code for it.