Data Validation - If Row is hidden Value = ""

[BobBing]

Hi Guys,

I am not the best with the programming side yet, and I am working with the data validation function trying to figure out how I can make certain cells blank if they become hidden.

Say for example someone chose "Yes" and started to fill out rows 35 and 36, and then decided that they did not actually want "Yes" in G34, so switched it to "No". The cells become hidden, but the actual data validation boxes still contain what they selected for G35 and G36. How can I have it so that when the rows are hidden the cell value would be blank?

Here is some of the code I am working with.

If Target.Address = "$G$34" Then
Application.EnableEvents = False
Select Case Target.Value
Case "Yes"
Rows("35").Hidden = False
Rows("37").Hidden = False
Rows("38").Hidden = False
Rows("204").Hidden = False
Rows("206").Hidden = False
Rows("208").Hidden = False
Case "No"
Rows("35:39").Hidden = True
Rows("204:209").Hidden = True
End Select
Application.EnableEvents = True
End If

[p24leclerc]

It would be a pleasure to answer your thread but you must first comply with rule #3 and enclose you code in CODE TAGS.
Refer to rules for detailed instructions to do so.

[AlphaFrog]

Please Login or Register  to view this content.