Help hiding rows based on drop down selection

First time poster here so I hope I do this correctly!

Using Excel 2010

I am creating a form that will display different rows if certain selections are made. For example; cells B70-B72 are a drop down list with two options, '-' or 'sqrt'. If none equal the 'sqrt' symbol then I want to hide row 56. If one does, then row 56 will be displayed.

If this is required, the drop-down list is selecting from Sheet:'List' where D7 is 'sqrt' and D8 is '-'

There will be quite a few of these dependencies so ideally, I would be able to have many instances of the code and I could simply edit which cells are the drop down, and which cells would be shown or hidden. So for example, I could run the same code but change the drop down list to be cell B27 and then rows 36,67, and 45 would be hidden or shown.


Any help at all would be fantastic.
Thanks!

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post, you need to be using the main 'New Post' or 'New Thread' page and not 'Quick Reply'.
To use the main 'New Post' page, click the 'Post Reply' button in the relevant thread.

On this page, below the message box, you will find a button labelled 'Manage Attachments'.
Clicking this button will open a new window for uploading attachments.

You can upload an attachment either from your computer or from another URL by using the appropriate box on this page.
Alternatively you can click the Attachment Icon to open this page.

To upload a file from your computer, click the 'Browse' button and locate the file.

To upload a file from another URL, enter the full URL for the file in the second box on this page.
Once you have completed one of the boxes, click 'Upload'.

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

Thanks for the workbook example.

First off, merged cells are evil. Please get rid of them if you can especially when you are going to introduce VBA. Makes life much harder.

Now, I see two bits of instructions on this sheet. In row 4 I see, "IF check then show rows 18-30 IF not then hide"

In row 26 I see, "only display if B15 is checked".

Are these the only two requirements you have right now?

See if you can adadt this.

To unhide the row you can change the TRUE to FALSE

I'm sorry I think I left something out.

The True and False was referring to the code. Right click on the sheet tab >> view code

One the cell where you have the check, the code is looking for an 'a'. Go to the cell where you want the check mark and change the font to Marlett. When you enter an 'a' the cell will turn into a simulated check box.

Did you use the file I attach? You said you removed all the merged cell but there were some left behind which I removed.

Also, instead of merged cell take a look at center across selection which gives the same look.

Try this, cell B3 and B13

Here is how you create data validation...

Select cell >> Data tab >> Data Tools >> Data Validation >> Allow: List >> Source: a,q

Set cell to Marlett font. Not sure if this is the symbol you want, but when using the marlett font (or wingdings or any other font) you are limited to what is there.

Whatever you use, it also needs to be updated in the code. Right now the code works off of 'a' (hides rows) or nothing (unhides rows).

Here is another alternative to consider

You are most welcome and glad you have a working model. Thanks for the feedback and don't forget to mark your thread as sloved

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Try

        If Target.Value = "a" Then
            Rows("12").Hidden = True
            Rows("18:30").Hidden = True
        Else
            Rows("12").Hidden = False
            Rows("18:30").Hidden = False
        End If

See how this does for you...

Private Sub Worksheet_Change(ByVal Target As Range)
    Dim Rng As Range
    Set Rng = Target.Parent.Range("B3, B13")
    If Target.Count > 1 Then Exit Sub
    If Intersect(Target, Rng) Is Nothing Then Exit Sub
    Select Case Target.Address
    Case "$B$3"
        If Target.Value = "Choice 1" Then
            Rows("17:22").Hidden = True
            Rows("23:26").Hidden = False
        ElseIf Target.Value = "Choice 2" Then
            Rows("23:26").Hidden = True
            Rows("17:22").Hidden = False
        Else
            Rows("17:26").Hidden = False
        End If
    Case "$B$13"
        If Target.Value = "a" Then
            Rows("27").Hidden = True
        Else
            Rows("27").Hidden = False
        End If
    End Select
End Sub

You will need to add the sheet unprotect and protect code lines to the main code. So unprotect before the actions, perform the actions then protect.