Hiding rows with a drop-down list

[Jo76hn]

Hi,

In the attachment file with an examlpe.

It's a part of the test checking the knowledge of the training participant.

When someone fills the fields and comes to the conclusion that, however,
he should not answer, then set to "Not applicable" and hides unnecessary
verses - checkboxes and fields which can be filled out.

Verses 2-5 should be hidden as we switch A1 "Not applicable"
but if someone type something into a "grey" cell's before switching to
"Not applicable" these verses, unfortunately, do not hide, even when
we erase everything from this cell?

The filter is based on the word STOP in the cell, that's why it does not work - how else to do it to work.

VBA code:

Private Sub Worksheet_Change(ByVal Target As Range)

If Me.FilterMode Then Me.AutoFilter.ApplyFilter

End Sub

[Richard Buttrey]

Is this truly representative of your data and this sheet only ever consists of rows 1:5 where 2:5 are capable of being hidden unless A4 of A5 contain a value?

I can't help thinking there's more to this so please clarify

[Jo76hn]

Hi,

Yes, this is a clipping from a large sheet -
but these are repeating elements (similar - sometimes is only checkboxes,
sometimes only fields which can be filled out and sometimes mix as it's here) that the participant retracts
if he / she thinks that the topic is not applicable
and should not be answered (then all lines 2-5 must be hidden - all
must be hidden or all must be filled out if he / she thinks that should be answered
but as I said if someone type something into a "grey" cell's before switching to
"Not applicable" these verses, unfortunately, do not hide, even when
he / she erase everything from this cell's).

Data from these fields are not used in other places.


Greetings,