Hide row on validation change

[lapta301]

I have a data validation list in C2 that contains numbers at present 36, 24, 16 & 0 although this could change.
What I would like is that if 0 is selected that row 6 is hidden and conversely is shown if any other number is selected.

As ever any help would be much appreciated

 

[Peter_SSs]

Not quite sure what you want if cell C2 is cleared, that is, contains nothing at all. This will hide row 6 if C2 is 0 but show if anything else, including blank.

Private Sub Worksheet_Change(ByVal Target As Range)
  If Not Intersect(Target, Range("C2")) Is Nothing Then Rows(6).Hidden = Range("C2").Text = 0
End Sub

If the user clears C2 and you want row 6 hidden for that too then

Private Sub Worksheet_Change(ByVal Target As Range)
  If Not Intersect(Target, Range("C2")) Is Nothing Then Rows(6).Hidden = Range("C2").Value = 0
End Sub

Post back if you need help with how to implement this worksheet_change event code.


I also suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[lapta301]

Peter
Thank you the code works a treat
And as suggested I have updated the profile to show 365

 

[Peter_SSs]

You're welcome. .. and thanks for updating your details.