Drop Down List value to Hide Rows

**rabbit8** · 07-13-2010, 11:22 AM

I've created a drop down list with two options( Single Wall and Double Wall), which I want to hide rows depending on the users selection.

When Single Wall is selected I want to hide rows 10 through 16.
When Double Wall is selected I want to hide rows 18 through 19.

Is there a simple solution to my question? I'm using excel 2003. Attaching the booklet.

Thanks!

**Marcol** · 07-13-2010, 12:02 PM

Try this in the worksheet module for sheet "RECYCLED CONTENT CALCULATOR"

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$A$4" Then
        Range("A10:A19").EntireRow.Hidden = False
        If Target = "Double Wall" Then
            Range("A17:A19").EntireRow.Hidden = True
        ElseIf Target = "Single Wall" Then
            Range("A10:A17").EntireRow.Hidden = True
        End If
    End If
End Sub

Demoworkbook attached

Hope this helps

**rabbit8** · 07-13-2010, 01:33 PM

This works perfect. Thank you for the help.

**ek2112** · 01-11-2012, 03:22 PM

Originally Posted by rabbit8

This works perfect. Thank you for the help.

I tried today and it works fine.

**koteshi** · 04-14-2014, 05:49 AM

I hope nobody minds I am reviving a dead thread but I am facing currently a similar problem:

I have an Excel 2007 sheet with a drop down list which looks like this.

\1
2014-04-14_172511.png

My plan is now that whenever someone picks the values CP320, CP320s or CP320n from the drop down list (marked yellow), the rows 12-14 (marked blue) will be automatically hidden. If the values CP321, CP321s or CP321n are selected the rows reappear.

I am pretty sure this can be done with a nice VB macro, however unfortunately I lack the skills to do it by myself. I've tried other approaches, like the one mentioned in this thread, but they all failed.

Anyone willing to help me on this one?

**arlu1201** · 04-15-2014, 01:00 AM

koteshi,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.