I know that function GetfieldSelections. It returns the value of last selections made. But what I need is, I want to represent the values of more than one selections in the caption of the chart.
Let me explain you some more,
I have the JoinYear as List box in a sheet. I have enabled chechboxes. So that I can make multiple Selections. Presently JoinYear field contains 4 unique values only. 2008-2011. If I selected 2008, 2009 and 2010(three years), then I want to display as 'Chart for FY08, FY09, FY10'.
Thanks for your idea. But I have already done that. And Its showing the recently selected value even we made multiple selections. I dont need the recently selected single value. I want to display all the whatever selected in that list box.