Podcast 1871 - 200 Checkboxes in Excel - Question?

[Hearntexas]

Hello Mr Excel,

Great training video!! Thank you.

I'm wanting to do something similar to the checklist you created in this podcast, but I want the checklist in column G,H, &I. I got it to work on column G, but how can I get it to work in all 3 columns in the same spreadsheet?

This spread sheet is a list of invoices and I what one column for entered, one for verified, and one for approved. Then we would put a check mark in the column as each task is completed.

Any help would be greatly appreciated!!

Thanks
Hearntexas

 

[Dryver14]

Mr Excel is not often here

You will see I have used or to get the columns if you want answers inbetween then 1 or 3 or 5 etc

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    If Target.Column = 1 Or Target.Column = 2 Or Target.Column = 3 Then
        If Target.Value = Chr(254) Then
            Target.Value = Chr(168)
            Cancel = True
        ElseIf Target.Value = Chr(168) Then
            Target.Value = Chr(254)
            Cancel = True
        End If
    End If
    
End Sub

 

[Hearntexas]

Thank you so much for your help!!!