lipse
10-23-2011, 07:11 PM
Hi Everyone, my first post here!
First of all sorry about my English, and, yes! im a macro newbie.
Im doing a project to do a dynamically report using filters.
These filters will be make using various listbox (5~7). The user will select a option in a listbox and the report will refresh automatically, select other option in other listbox and then refresh again.... and go...
Im dont have the code yet (im thinking now about the code), but im thinking how i do that...
I think about a module (procedure) to apply various autofilters (Worksheets("").Range("A1").Autofilter bla bla bla), and after each user selection ill refresh the worksheet (using change event from listbox), but im releasing this idea because how can i do when user release the filter from one listbox? Store every filter in array and apply everyone again?
I thinked about Advanced Filtering, but, i dont know how to use and in my point isnt the better way...
So... im here to ask for help, im trying to obtain a "better way" from you... expert`s...
Thanks in advance.
First of all sorry about my English, and, yes! im a macro newbie.
Im doing a project to do a dynamically report using filters.
These filters will be make using various listbox (5~7). The user will select a option in a listbox and the report will refresh automatically, select other option in other listbox and then refresh again.... and go...
Im dont have the code yet (im thinking now about the code), but im thinking how i do that...
I think about a module (procedure) to apply various autofilters (Worksheets("").Range("A1").Autofilter bla bla bla), and after each user selection ill refresh the worksheet (using change event from listbox), but im releasing this idea because how can i do when user release the filter from one listbox? Store every filter in array and apply everyone again?
I thinked about Advanced Filtering, but, i dont know how to use and in my point isnt the better way...
So... im here to ask for help, im trying to obtain a "better way" from you... expert`s...
Thanks in advance.