Hi,
File with an examlpe - https://www.dropbox.com/s/pcn5ai8zamb0hpg/Example 1.xlsm?dl=0
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
File with an examlpe - https://www.dropbox.com/s/pcn5ai8zamb0hpg/Example 1.xlsm?dl=0
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