Case Range Help

[MonTheEck]

I have a VBA function set up whereby certain cells are displayed after ALL dropdowns are selected from 3 cells (D5,D6(Misc 1 or Misc 2) and D7)

I am looking to have 3 separate cases that return certain outcomes. For example, If D7 shows "CASE 1" this will only shows rows 15 & 19 (Row 17 will be hidden). If D7 shows "CASE 2" this will show rows 15 & 17 (19 will be hidden). Finally, if D7 shows "CASE 3" then this will show row 19 only (15 & 17 will be hidden).

PS - D6 only has 2 options "MISC 1" and "MISC 2". If "MISC 1" is selected, row 26 will show. If "MISC 2" is selected row 26 will be hidden.

I am also looking to add more options in i.e. "CASE 4,5,6,etc" that show and hide other rows but I'll tackle that another day.

I have this VBA but it doesn't work for CASE 1. Could someone offer their advice? PPS - I am new to VBA and it pickles my head at times.

Thanks.

Please Login or Register  to view this content.

[davesexcel]

Please edit your post and add code tags to the code.-
-
-
AA CodeTags.jpg

[PCI]

In addition to Davesexcel, attach an Excel sample file, it helps to debug

[MonTheEck]

Updated. Apologies.

[PCI]

Is there a file attached ??

[MonTheEck]

Thanks for your help. I managed to sort it by simplifying everything. I think I had been looking at it for so long my eyes (and brain) were fried! (The joys of being a newbie to VBA! Thanks

[WideBoyDixon]

Based on your description and some code simplification, I think this does what you're after:

Please Login or Register  to view this content.

WBD

[MonTheEck]

Perfect. Thanks WBD