filtering to show items in a listbox
I have a protected spreadsheet that I would like to allow users to filter. I
have previously setup macros to allow them to filter on column A which has 5 different categories on it. However, they want to filter on various combinations of those categories. Is it possible to create a listbox in a userform that displays the 5 categories, and they can multi-select the options to pick which ones they want to see. Then, the macro can read the categories selected and filter to show the rows that match any one of those categories? If this isn't possible, is there any other way of doing it, other than writing a different macro for every combination possible? |
filtering to show items in a listbox
hi,
It could help u: Go to Menu data-validation-allow-List-Put ir values like "BCA","MCA" as optional values "eileenj" wrote: I have a protected spreadsheet that I would like to allow users to filter. I have previously setup macros to allow them to filter on column A which has 5 different categories on it. However, they want to filter on various combinations of those categories. Is it possible to create a listbox in a userform that displays the 5 categories, and they can multi-select the options to pick which ones they want to see. Then, the macro can read the categories selected and filter to show the rows that match any one of those categories? If this isn't possible, is there any other way of doing it, other than writing a different macro for every combination possible? |
All times are GMT +1. The time now is 08:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com