datastream
New Member
- Joined
- Apr 17, 2002
- Messages
- 14
I need VBA code to control auto filter criteria and operators.
For example, if a user selects vehicles > $20,000 in a userform, the filter will automatically set the autofilter on the data in the worksheet to "greater than" and "20,000" for the value and display only those in the worksheet over 20,000. I know how to use autofilter, but the user will only be entering values in user forms and i need it to control the autofilter on a sheet.
For example, if a user selects vehicles > $20,000 in a userform, the filter will automatically set the autofilter on the data in the worksheet to "greater than" and "20,000" for the value and display only those in the worksheet over 20,000. I know how to use autofilter, but the user will only be entering values in user forms and i need it to control the autofilter on a sheet.