Using a Checkbox to Hide Rows based on Cell Value

**leedjc** · 09-25-2018, 03:34 AM

Hi all

I've got a spreadsheet that I'm using a checkbox to hide rows based on whether the checkbox is checked or not. I've got it to work if I specify which rows the condition relates to.

However, I'd like to turn it up a notch, and specify the whole sheet as a range, and hide all rows which contain a predetermined text value in a specified column.

Here's the current code:

 If CheckBox1 = True Then
                Sheets("Output").Rows("72:76").EntireRow.Hidden = False
                Else: Sheets("Output").Rows("72:76").EntireRow.Hidden = True
        End If

This works fine, but relies on a specified range. I've tried lots of ways of doing this the alternative way, but can't achieve what I want

Essentially, when checkbox 1 is checked, I want all rows which contain "string" in column K to be hidden.

Any help would be much appreciated!!

**WideBoyDixon** · 09-25-2018, 03:45 AM

Try something like this:

Dim lastRow As Long
Dim thisRow As Long

If CheckBox1 = True Then
    Sheets("Output").Cells.EntireRow.Hidden = False
Else
    lastRow = Sheets("Output").Cells(Sheets("Output").Rows.Count, "K").End(xlUp).Row
    For thisRow = 2 To lastRow
        If Sheets("Output").Cells(thisRow, "K").Value = "string" Then
            Sheets("Output").Cells(thisRow, "A").EntireRow.Hidden = True
        End If
    Next thisRow
End If

WBD

Using a Checkbox to Hide Rows based on Cell Value

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Using a Checkbox to Hide Rows based on Cell Value

Re: Using a Checkbox to Hide Rows based on Cell Value

Thread Information

Users Browsing this Thread

Similar Threads

Hide/Unhide Rows based on column data using checkbox

Userform/checkbox hide/unhide rows based on cell value

Hide rows based on userform checkbox

[SOLVED] User form/checkbox hide/unhide rows based on cell value

[SOLVED] Checkbox VBA - Hide/Unhide Rows and/or Columns based on cell values

Macro cannot hide rows based on cell linked to checkbox

Bookmarks

Bookmarks

Posting Permissions