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.

Originally Posted by royUK

have a look at this

This is gonna help me to put up my code in a better way.
It dosent do (atleast what i can see) what i wanna accomplish.

To copy and filter on another place in the sheet. So that in the following boxes the list i get up is dependent on what i choosed in my first criteria (Dimension)

Also the other thing that i wanna get rid of. Im trying to get around the need to press my filter button to do the filtering. What i want is when i choose a certain dimension. it instantly filter my database without me pressing the filterbutton. This is to make it smother with actually filter out whats gonna be shown in my second and third combobox

Originally Posted by royUK

Use the ComboBox change event to change the form. You should be able to adapt the code to use advanced filter, or simply copy the Filtered range to another range.

Gonna take a deeper look into it. The problem as it is i basicly have no VBA experiance as it is