Use VBA to hide / unhide row depending on a selection from a dropdown

[Walkie1994]

Hi there,

Im creating a document checklist and i need a row to be hidden until a certain choice is chosen from a dropdown

The dropdown is in B6, and has three choices (England, Scotland, Wales)

If the user selects England, i then need row 14 to appear which will make the user then make another selection,

If the user selects one of the other two options then row 14 can stay hidden,

Ive tried a couple of VBA's from other threads but i cant get them to work (im probably doing something wrong)

Thanks in advance!

 

[Fluff]

Hi & welcome to MrExcel.
How about

Private Sub Worksheet_Change(ByVal Target As Range)
   If Target.CountLarge > 1 Then Exit Sub
   If Target.Address(0, 0) = "B6" Then
      Rows(14).Hidden = Not Target.Value = "England"
   End If
End Sub

This needs to go in the relevant sheet module.

 

[Walkie1994]

Hi & welcome to MrExcel.
How about

Private Sub Worksheet_Change(ByVal Target As Range)
   If Target.CountLarge > 1 Then Exit Sub
   If Target.Address(0, 0) = "B6" Then
      Rows(14).Hidden = Not Target.Value = "England"
   End If
End Sub

This needs to go in the relevant sheet module.

Thanks for this, i have just tried this but it keeps coming up with compile error: invalid outside procedure when i then go to change one of the options in the drop down in B6

 

[Fluff]

Did you copy & paste the whole code?

 

[Walkie1994]

Did you copy & paste the whole code?

Hi, Yes i did although i must have done something wrong as it is now working, but it hides the row when England is selected as well as the other two options.

 

[Fluff]

Are you entering England, as opposed to england, or ENGLAND? As VBA is case sensitive.

 

[Walkie1994]

Are you entering England, as opposed to england, or ENGLAND? As VBA is case sensitive.

I must have entered it wrong as its now working, thanks!

 

[Fluff]

You're welcome & thanks for the feedback.