EXCEL: Check box as an X

General Questions
#1

Are there any check boxes in Excel that produce an X when clicked instead of the standard check mark?

#2

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
#3

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.

#4

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.