Introducing Checkboxes in Excel

You can also create a checkbox toggle with Wingdings (o in Wingdings is a blank checkbox, x in Wingdings is a filled checkbox). 

I made a video about how to do this, but if you just want the code, I have that below too.  I used the Wingdings in Column C, just make sure to revise the code as needed. 

YouTube Video: https://youtu.be/sgDZvJlooVU 

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    ' Specify the range where the checkboxes are located (column C)
    If Not Intersect(Target, Me.Range("C:C")) Is Nothing Then
        Cancel = True ' Prevents entering edit mode on double-click
        
        ' Check if the font is Wingdings and if it is a checkbox (either "o" or "x")
        If Target.Font.Name = "Wingdings" Then
            If Target.Value = "o" Then
                ' If the value is "o", change it to "x" (checked box)
                Target.Value = "x"
            ElseIf Target.Value = "x" Then
                ' If the value is "x", change it back to "o" (unchecked box)
                Target.Value = "o"
            End If
        End If
    End If
End Sub