VBA Code Needed that will Hide / Unhide a row when used with a "Check Box"

[Barryoffshore]

I need a VBA code that will when used with a Form Control "Check Box" will unhide / hide a row. To be more exact, I'm needind the code to "Hide" row 34 when unchecked and "Unhide" the same row when checked. Can someone help me please. By the way, I'm using Excel 2010. Thank you!!!

 

[mikerickson]

To get the value of a Forms's checkbox, one can use the ControlFormat property of the shape

With Sheets(1)
    .Rows(34).Hidden = (.Shapes("Check Box 1").ControlFormat.Value = xlOn)
End With

 

[Barryoffshore]

Dave - thank you VERY MUCH!!! I'm sorry you had to lead me step by step, but you took the time and effort! Thank you again, my sheet is working perfectly now!

 

[dmt32]

Dave - thank you VERY MUCH!!! I'm sorry you had to lead me step by step, but you took the time and effort! Thank you again, my sheet is working perfectly now!

Your welcome - Glad we got there in the end.

You might find this link useful:http://office.microsoft.com/en-gb/e...ivex-controls-on-a-worksheet-HA010237663.aspx

Dave