Excel Hide Rows When Value Entered

Question

I have to develop an excelsheet where a row is hidden automatically when the value is enter. There is 3 condition

An example like this:

Condition 1

If cell C16 = Value 1 to 3

Row 17 -> automatically hide row

Row 18 -> automatically hide row

Row 19 -> automatically unhide row

Condition 2

If cell C16 = Value 4 to 6

Row 17 -> automatically hide row

Row 18 -> automatically unhide row

Row 19 -> automatically hide row

Condition 3If cell C16 = Value 7 to 9

Row 17 -> automatically unhide row

Row 18 -> automatically hide row

Row 19 -> automatically hide row

etc.

Can you please help me?

Thanks a lot

Answer 1

1. Make a backup of your workbook. 
2. Open your workbook and ALT+F11
3. Locate your Workbook name in Project Explorer Window
4. Double click on your worksheet name
5. Copy paste the Macro code given below
6. Save your file as .xlsm
7. If you want to add / change conditions change appropriately

Private Sub Worksheet_Change(ByVal Target As Range)

    On Error GoTo ExitSub

    If Target <> Me.Range("C16") Or Target = "" Then Exit Sub

    Application.EnableEvents = False

    Select Case Target

        Case 1 To 3

            Rows("17:18").EntireRow.Hidden = True

            Rows(17).EntireRow.Hidden = True

            Rows(19).EntireRow.Hidden = False

        Case 4 To 6

            Rows(17).EntireRow.Hidden = True

            Rows(19).EntireRow.Hidden = True

            Rows(18).EntireRow.Hidden = False

        Case 7 To 9

            Rows("18:19").EntireRow.Hidden = True

            Rows(17).EntireRow.Hidden = False

        Case Else

            Rows("17:19").EntireRow.Hidden = False

    End Select

ExitSub:

    Application.EnableEvents = True

End Sub