Using a Toggle Buttons to Hide Rows Based of a Value or Text in a Column

[kdgreen]

I am trying to use macros to hide certain rows based on a value of a column which is usually a text value. I am planning a using multiple toggle buttons to hides rows that don't meet each criteria. I am kinda lost on how to begin any help and advice to get me through this would be greatly appreciated. Any additional information you might need to help me just let me know.


Thank you for anyone that reads this and tries to help in anyway they can.

 

[alansidman]

What is the criteria to hide the rows? In which column will this criteria appear.

 

[kdgreen]

Column I: UHF, VHf
Column K: Top, Side, Invert, Stack, Special
Column M: Hpol, Cpol, Epol

 

[kdgreen]

I was finally able to get the toggle button to hide the cells when clicked but I don't know how to unhide the cells when the button is toggled again the code I used was:

Private Sub ToggleButton1_Click()
Application.ScreenUpdating = False
For Each cell In Range("I16:I303")
cell.EntireRow.Hidden = cell.Value = "VHF"
Next cell
Application.ScreenUpdating = True


End Sub

 

[alansidman]

Need to run out and do some errands. Will work on this later today or tonight if no else steps in.

 

[kdgreen]

Thank you for any time you put in to this to help me out