Hiding Row14 in Excel if Cell D13 is greater than 1

[CMAnderson]

I am creating a template to fill out for work. Looking to have Row 14 appear ONLY if Cell D13 is greater than "1".

Thanks in advance.

 

[Joe4]

Welcome to the Board!

That will require VBA code, but when should the VBA code run?
When the workbook opens?
When the value in cell D13 is updated?
How exactly is the value in D13 updated (is it a manual edit, or the result of a formula)?

 

[CMAnderson]

Thank you! sorry, i am still fairly new at this... i will try to explain a little better..
Cell D13 will be blank when the worksheet opens. The end user of this form will need to tell how many lists a customer has provided. if the customer has only provided 1 list, i would like for row 14 to remain hidden. if the customer has provided more than 1 list, i would like for row 14 to appear so that more details regarding the list work will appear.

 

[Joe4]

Right-click on the Sheet tab name at the bottom of your screen, select "View Code", and paste this code in the resulting VB Editor window.
This should do what you want:

Private Sub Worksheet_Change(ByVal Target As Range)

'   Run when cell D13 is updated
    If Not Intersect(Target, Range("D13")) Is Nothing Then
        If Range("D13") > 1 Then
            Rows("14").EntireRow.Hidden = False
        Else
            Rows("14").EntireRow.Hidden = True
        End If
    End If
    
End Sub

 

[CMAnderson]

this is great. Thank you, my only issue now is that the row i am hiding contains check boxes, when the row hides, the check boxes don't hide with the row, how can i fix this?

thanks in advance!

 

[Joe4]

I have never done that, but here are some old threads that dealt with the issue:
https://www.mrexcel.com/forum/excel-questions/718055-hide-checkbox-when-row-hidden.html
https://www.mrexcel.com/forum/excel-questions/23889-hide-unhide-rows-checkbox.html