auto hide/unhide??

[megaman666]

Hi, im creating a form for people to complete in excel. I need to have a 'full' and 'simplified' version of the form.. The default view would be the simplified version, which would include some rows of superfluous data to be hidden. One of the fields will be a drop down list with 'yes/no' options- is there a way to unhide the additional fields if 'yes' is selected and to have them hidden if 'no' or (no value) is chosen?

 

[megaman666]

p.s. happy to provide more information if needed?

 

[megaman666]

ok, so using the following code I can 'almost' get this to work.....

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 5 And Target.Row = 15 And Target.Value = "None" Then
Application.Rows("16:21").Select
Application.Selection.EntireRow.Hidden = False
Else
Application.Rows("16:21").Select
Application.Selection.EntireRow.Hidden = True
End If
End Sub


Problem I have now, If you select 'none' the rows unhide, which is great.. but then if you populate one of the fields (say, in row 16) then it hides again, even tho 5:15 still = 'None'?

Any help would be trully appreciated.

 

[megaman666]

no takers? any ideas at all would be really welcomed