phendrena
10-29-2008, 08:37 AM
Hello,
Is it possible to create a user form that will search for data entered into (that is on a worksheet) it and then display this information on the user form (table formatted)? Would any be able to provide and suggestions on how best to do this.
Let me explain a little more.....
The userform will search based on the following criteria :-
Dealer Number, Dealer Name, Month, Scheme
The results of this search will then be displayed on the userform in a listbox.
Assuming that any of the search criteria is left blank then the the user form will search and include all the data in the appropriate column on the worksheet - for example, if the user leaves the Month field blank then the user form will return results for all months.
Can this be done?
Thanks,
Is it possible to create a user form that will search for data entered into (that is on a worksheet) it and then display this information on the user form (table formatted)? Would any be able to provide and suggestions on how best to do this.
Let me explain a little more.....
The userform will search based on the following criteria :-
Dealer Number, Dealer Name, Month, Scheme
The results of this search will then be displayed on the userform in a listbox.
Assuming that any of the search criteria is left blank then the the user form will search and include all the data in the appropriate column on the worksheet - for example, if the user leaves the Month field blank then the user form will return results for all months.
Can this be done?
Thanks,