Strikethrough columns A-J with double click

[sdl93]

Hi everyone,

So I'm a bit of a novice when it comes to excel and I'm looking for a bit of advice/guide on achieving the above. I have a huge list of over 2000 tasks that my work is working through. I want to be able to strikethrough the whole row from columns A-J with either a double click or checkbox once the task is complete.

It seems the double-click method may be the easiest to achieve, I tried to figure it out using checkboxes but realised they would need to be manually linked, which just isn't feasible with over 2000 entries. Any help in this matter would be greatly appreciated. Below is an example of how I would like it to look. Is this possible with one double-click or would it need to be each column?

 

[RobP]

Taking from Joe's idea .. this code will allow you to click anywhere on the row, not just in your defined range :

Option Explicit

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    
        With Sheet1
            
            Range("A" & Target.Row, "J" & Target.Row).Font.Strikethrough = Not Range("A" & Target.Row, "J" & Target.Row).Font.Strikethrough
            
        End With
    
End Sub

 

[sdl93]

Amazing guys! You've all been incredibly helpful. Now to try and remember all of this and apply it to future tasks.