Hello everyone,
some months ago I opened another thread similar to this one, but due to my minimal knowledge about the topic I ended with not giving you the necessary info...
Now, after some studying, I think I realized what I need to complete my work, which is a dashboard built from several pivot tables and filtered by some slicers and three dependant ActiveX comboboxes. The first combobox should filter the "Product" field, the second the "W.O." field and the third the "Operations" one.
Currently I almost managed to complete the first combobox, but I still have some problems due to my limited knowledge. I would like to learn and would really appreciate your help!
My current goals are as follows:- make the macro I wrote more stable (I am a beginner with VBA and every tip is always welcome!), because sometimes, if I delete the names of the products filtered in the combobox itself, they might even disappear;
- being able to clear the comboboxes and make the pivot tables return as before;
- filter the "Product" and "Progress" tables, located in their respective sheets (it seems like I am not able to filter tables which do not have the "Product" field in the pivot filter...);
- connect (if possible, because it would be a gem!) the slicers to the comboboxes, so that they react whenever they filter a product.
Down below you have my code and my attached sample file.
Thank you very much in advance!
Bookmarks