The logic of my VBA code is to:

1). Present an InputBox for the user to enter a file of .CSV data to be imported.
2). Import the data from that file to a separate worksheet
3). Dynamically create a "xlBarClustered" chart on another worksheet.
4). Allow the user to double-click any of the elements presented on the chart which will then extract further more detailed data from (2) specific to the element selected & present that data as another chart on a final worksheet.

I have done (1), (2) & (3) and they're all working but I cannot find out how I can do (4). At the moment I have used:

Selection.OnAction = "Drilldown"

to execute the Drilldown macro. Apart from "OnAction" being a single click rather than a double-click, there is no element information selected. The

ActiveChart.GetChartElement X, Y, IDNum, a, b

tells me that IDNum = 2 (i.e. the chart has been selected - which, of course, it has!!).

What do I need to do to get (4) working?????