VBA Combo Box hide/unhide cells?

[MichaelRSnow]

Does anyone know any VBA code where the option selected from the drop down list (ComboBox) hides/unhides rows.

i.e. If A1 had a ComboBox with a list of 4 names, Name1, Name2, Name3, Name4

if Name 2 is selected row 3 becomes unhidden?

 

[baitmaster]

An advanced version of this is described in two previous threads, see here for details: http://www.mrexcel.com/forum/showthread.php?t=566787

As for your requirement, do you just want one of four hard-coded rows to be visible, and the other 3 hidden?

Option Explicit
 
Private Sub ComboBox1_Change()
Sheet1.Rows(2).EntireRow.Hidden = True
Sheet1.Rows(3).EntireRow.Hidden = True
Sheet1.Rows(4).EntireRow.Hidden = True
Sheet1.Rows(5).EntireRow.Hidden = True
Select Case ComboBox1.Value
    Case "Name1"
        Sheet1.Rows(2).EntireRow.Hidden = False
    Case "Name2"
        Sheet1.Rows(3).EntireRow.Hidden = False
    Case "Name3"
        Sheet1.Rows(4).EntireRow.Hidden = False
    Case "Name4"
        Sheet1.Rows(5).EntireRow.Hidden = False
        
End Select
End Sub

 

[MichaelRSnow]

Thank you, Exactly, unhide row 2, and hide rows 3, 4, 5 etc