Using Checkboxes to Hide Individual Rows, One Atta Time, with VBA

[atypicalguy]

Hey All!

First post on this board, really impressed with and appreciate this community!

I'm coming in with near to 0 knowledge of VBA, so any and all explanations/ideas/troubleshoots are appreciated.

I've got a task list that I'm wanting to mark completions with a ticked checkbox, and once the checkbox is ticked, it hides it's row.

I've been browsing this board and have found some macros for hiding multiple rows via a single checkbox, but am having trouble coming up with a macro for individual rows with their own checkbox.

Any and all help is appreciated!

 

[atypicalguy]

@Fluff That's what I thought... that's not the best option since it would involve scrolling through ~4500 rows of data to place the "yes/no" in the "Scheduled?" column.

It won't be the prettiest, but I'm thinking hiding the rows manually might be the easiest at this point

 

[Fluff]

What cell is the formula in?

 

[atypicalguy]

B24

 

[Fluff]

Ok, you could use this.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
   If Not Intersect(Target, Range("B24#").Offset(, Range("B24#").Columns.Count).Resize(, 1)) Is Nothing Then
      Target.EntireRow.Hidden = True
      Cancel = True
   End If
End Sub

Place it in the code module for that sheet & when you double click in the 1st column after the spill range, that row will hide.

 

[atypicalguy]

That worked like a CHARM and looks slick!

@Fluff thank you from the bottom of my no-longer-frustrated-heart!

 

[Fluff]

Glad we could help & thanks for the feedback.