Hide Rows Based on Selection in Form List Box

**mpluers** · 01-03-2013, 05:56 PM

I have a questionnaire (Worksheet "Decisions") whose answer is formatted as a listbox with possible answers A, B, and C. If the answer is C, I want to hide lines 40-43 on Worksheet 2 ("Project Plan"). If the answer is A or B, I want for the lines to remain unhidden.

I'm trying to use the following, but I'm getting an error 424 Object Required.

Any suggestions?

Please Login or Register  to view this content.

**Winon** · 01-03-2013, 06:08 PM

Hi mpluers,

Please take a moment to revisit the Forum Rules regarding wrapping of any Code.

Once you have done that, then please upload a sample WorkBook complete with your Dropdowns etc. for us to have a look at.

**mpluers** · 01-04-2013, 12:45 PM

Thanks! Instead of apologizing here I'll just be really nice to the next person who violates one of my forums rules : )

I think that I did what you requested (and am uploading the workbook) - please let me know if I misunderstood.

Thanks!