Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get the list from Autofilter after filter some criteria
Dear All and MVPs, I have created my userform and there are some dropdown box
there. In order to ease and simply user on selecting, this userform works similarly and base on Autofilter from the workbook. E.g., a file contains Company Name and Product Name. Since some companies may carry more than one product, after user selected the company on my userform, the product Combo(dropdown) listbox only shows the product(s) the company carries. My method is using Autofilter on the worksheet and set the criteria as the user selection on the workbook. How can I get the autofilter list from the Excel autofiler? Or I have to do looping to check? Please advise. Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to filter list based on multiple criteria | New Users to Excel | |||
use list of criteria in filter | Excel Discussion (Misc queries) | |||
AutoFilter Pull Criteria from one sheet and custom filter on other | Excel Programming | |||
Improve autofilter combine conditionals with filter criteria | Excel Worksheet Functions | |||
Product Price List with 14k records, filter w/out using AutoFilter | Excel Worksheet Functions |