Building a selection tool - problem with the range

Hello everybody.

I am building a selection tool with a whole list of products. this excel list is filtering all the products based on the criteria. The criteria are:

Type
Height
Lengte
Watt D7:D30

But i have created a filter that is based on the type value in a cell. I have the following two problem.

- after typing the value i have to press enter for filtering, can this be done automatic?
- anf for the criteria watt I want that excel filter a range. for example: if i press the value "1000" i want that is filter from 985 to 1015

Who can help me with this problems?

Please Login or Register  to view this content.

I have already a other solutions. i am now using this code:

Please Login or Register  to view this content.

This is for 5 filter based on cell type value, I want to use the code below as watt filter for minimum - maximum, but i can not find a way to add this in the code above. Can somebody help me with this.

Please Login or Register  to view this content.

Hopefully one of you guys want to help me with this problem

Yes thankyou it works!