Userform: Make a advanced filter script "filter" when a combobox is altered

Hey!

Completly new to VBA and macro in general.

Trying to build a small Userform Program that is gonna search in a worksheet depending on what i choose in my diffrent comboboxes and then return some valuves (havent got to that point yet so not important now)

There is proberly alot better and smother ways to do this then how im trying to do it (and ofcourse you can come with suggestions)

My problem now tho is that I start the program and im gonna decide on a Dimension. lets say i choose 2". Then im gonna choose Type

And heres the thing, i only want to show the diffrent "types" that you can get in the dimension 2". And the only way i could come up with this was using excels advanced filter.


Two problem occur when using this script

First, when i start with choosing Dimension i then have to click my "Add" button to paste it in the Advanced filter criteria i have in my workbook and then press filterbutton to acctually filter my "database".

Second, When i use a Advanced filter script to make this work and "filter on place" my options in my boxes after dimension dosent change since my comboboxes is still looking for my information in the same cells and with the advanced filter those cells is only hidden. I know how to copy the filter to another cell with a macro but i dont know the "script code" to do this. Can anyone help out on this?

For my first problem is there any code to make this work on altering the cell?

Feel free to come with suggestions on how i can make filtering databases with a better method then advanced filter script or just help out with code as the script is now.