Are there any check boxes in Excel that produce an X when clicked instead of the standard check mark?
I couldn’t find one but you can write some VBA that can turn any cell into a checkbox with an X. That may not solve your root problem, but I don’t know what your root problem is, or why you want an X instead of a checkmark.
The following code installed for a specific worksheet will cause the value of A1 to toggle from “X” to null when it is selected.
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If Target.Address = Range("A1").Address Then If Target.Value = "" Then Target.Value = "X" Else Target.Value = "" End If End If End Sub
There’s a checkbox option available from the Forms toolbar (radio buttons too, I think, from memory). However, it isn’t embedded in a cell, you have to move it to where you want it to be.
Both the Forms checkbox and the ActiveX checkbox show checkmarks when checked. The OP wants the box to have an X when checked, like a checkbox in an MS Word form.