Loop through Combo box options to change data in OLAP cube

I have a spreadsheet that uses combo boxes to change the options in an OLAP cube so when you change selections the chart and data subsequently change.

I would like to create a macro that loops through all the options in one of my combo boxes and produces charts for each selection in a seperate document.

I have recorded changing the combo box and I can only see the application.run of my macro assigned to the combo box.

Note: there is no form on this spreadsheet, the combo boxes are on the sheet itself.

Thanks

John