Problem with VB hiding rows

[b69]

I have created a questionaire where you first select the critera for the questions. The Questionaire Worksheet has a selection of drop down boxes in column D. The Selection Worksheet identifies the what has been selected. The Applicability Workheet determines which questions should be asked.
On the Decisiontree Worksheet I have 3 buttons.
If a number of the questions are answered and the the Show Unanswered questions selected when the SHOW All Questions again it hides the rows that have been answered. I cant work out what Is wrong? This has taken me quite a bit to get to this stage so any help will be greatly appreciated.

Thanks

Since My last post solved my final question from another post.

Thank you very much VBA NOOB. I am so happy now.

[VBA Noob]

Not 100% clear what you're asking for but see if the below helps

To show all records use

Please Login or Register  to view this content.

To show no unanwered questions

Please Login or Register  to view this content.

To show no anwered questions

Please Login or Register  to view this content.

VBA Noob

[b69]

I tried changing the VB code for the buttons and it does not work right.

The button with SHOW NO Sections should only show the rows that split the Sections.

EG if any question from cells E11 to E48 are NO then F10 changes to NO and so for the SHOW NO SECTIONS this should show a section listed as NO. Like wise for the next section rows E51 to E80 are NO then F50 changes to NO.

In the example the sub section are Rows 10 and 50. Note I have cut another 10 Subsections from the example and would need to be able to select those as well.

Hope this explains it better.

[VBA Noob]

Just filter on no you would use

Please Login or Register  to view this content.

VBA Noob

[b69]

VB Noob

Thanks, I have amended the workbook and the Show unanswered works and then Show all works.

But the Show Sub Sections = NO button needs to show only the rows with the Yellow (highlighted yellow only to stand out from the questions) Sub Heading and where the Column F in these rows and other Sub sections that I add equals NO.

Thanks

[VBA Noob]

Wouldn't it just be changing Col E to Col F

Please Login or Register  to view this content.

VBA Noob

[b69]

VB Noob

Thanks once I changed the field to 6 then it works great.

Your a star.


Sorry to be a pest but I am considering adding an option to show the number of questions in total and then the number of questions still to be answered but in a field next to the buttons.

How can I do that efficently?