Hello MrExcel,
Some website mentioned that using "Class Module" can make our code more clean.
I also want to try it that way.
I have create a class named "Car" which contain 3 main properties. Price+Color+Size.
In another worksheet, i have table for each car which each of them contain price+color+size in column B,C,D(A is used for CarID).
I want to list all car with price<20000 AND color is red AND size is XL then print all qualified cars to another sheet.
How to do this with class module method ?
Some website mentioned that using "Class Module" can make our code more clean.
I also want to try it that way.
I have create a class named "Car" which contain 3 main properties. Price+Color+Size.
In another worksheet, i have table for each car which each of them contain price+color+size in column B,C,D(A is used for CarID).
I want to list all car with price<20000 AND color is red AND size is XL then print all qualified cars to another sheet.
How to do this with class module method ?
