Hiding rows with a drop-down list

Fran76cis

New Member
Joined
Apr 28, 2019
Messages
1
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
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Watch MrExcel Video

Forum statistics

Threads
1,102,369
Messages
5,486,449
Members
407,547
Latest member
Sankarasrinivas

This Week's Hot Topics

Top