Combo box print all options

[julien_hh]

Dear All,

I am working on a dynamic dashboard, where graphs and tables are linked to a Combo box.

I would like to create a Print button (macro) to print every existing views from the available options from the Combo box.

I give you some details on my file :

I work with 2 sheets :
- "DATABASE" where I have a list in range I8:I18 to feed the Combo box
- "Sales Analysis" where I have a Combox box named "Drop Down 187". In this sheet, I have graphs and table in range A30:Q69 which change in function of selection in the Combo box.

How can I print range A30:Q69 in "Sales Analysis" sheet with all available options from the Combo box ?

My list is not coming from a dropdown list created with Data validation but I have implemented a button through Developer > Insert Combo box (Form Control)

Thank you guys for your valuable support !

[julien_hh]

Anyone know how to print every options of a combo box?