"VBA code to hide/show rows based on multiple selection of drop down list.

Hi All,

Relatively new to VBA stuff in Excel, kind of have things figured out but this is beyond what I can figure out. In short, I currently have a code that will "hide/show" lines/columns based on a cell selection made. Works great (thanks to the folks that helped me tweak that that). If a cell value is "yes", then it shows the rows, if a cell value is "no" then it keeps the rows hidden. What I am trying to accomplish now is if there is a way to "rewrite" the code based on multiple list values (no repetition). Example: User can choose multiple items from a drop down list of values at the same time, example: multiple list could have values to select of "Select One", "None", "1", "2", "3", "4", "5". They can select as many items from the list that they need. IE: If the default is "Select One" then no rows show, If "None" is selected then again no rows will show. If they select only "1" from the multiple list values then row 10 will show. If they select "1, 3, 5" from the multiple list value then rows 10, 12 and 14 will show. If possible I also need to set it up so that if "Select One" or "None" are selected along with "1" (or any other value in the list) that it still has the rows hidden so there isn't an "error". Any help would be greatly appreciated. (as a side note, I am hoping that I can add "multiple" drop down lists on the same sheet that will do the same thing. IE: second drop down list could have apple, banana, orange etc. and it too would show rows 18, 24, 46 (as an example) on the same sheet based on those different ranges/selections. ))

Hope that makes sense. Thanks in advance to all.

Current code is below (yes there is a lot of lines that I need to hide/show...not fun on my end but if I can get it to work with one "range" I should be able to duplicate it over the ranges that I need )

Please Login or Register  to view this content.

[code]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I did it for you this time. Please read forum rules. Thanks

Administrative note
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
Thanks