Hello everyone,
I am having a lot of problems in finding some material which could help me learn how to filter a pivot table with an ActiveX combo box set in another Sheet and I was hoping in some help of yours.
I would like to make a dynamic combo box, which updates automatically whenever its source changes (e.g. when I insert a new product).
If necessary, this is the link for a very simple example of mine: Example for combo box.xlsx
Thank you in advance!
AKing_1st
P.S. What I would really like to accomplish is having three dependant combo boxes, but I fear that would be asking too much. Feel free to help me with just one combo box, if you prefer. I'll try doing the rest.
I am having a lot of problems in finding some material which could help me learn how to filter a pivot table with an ActiveX combo box set in another Sheet and I was hoping in some help of yours.

I would like to make a dynamic combo box, which updates automatically whenever its source changes (e.g. when I insert a new product).
If necessary, this is the link for a very simple example of mine: Example for combo box.xlsx
Thank you in advance!
AKing_1st
P.S. What I would really like to accomplish is having three dependant combo boxes, but I fear that would be asking too much. Feel free to help me with just one combo box, if you prefer. I'll try doing the rest.
