How do I change a check box checkmark to an X

[Jas]

I have created a form in excel to link to check boxes but on printing the
checkmark is too small for many to see easily. The check boxes I create in
Word turn out to have a large X through them as default. How can I change
the Excel checkmark to an X or be more legible on printing?

 

[Jim Cone]

The size of the checkmark cannot be changed.
However, you could change the caption when it's clicked.
Assuming you have a checkbox from the forms toolbar and
its name is "Check Box 2" then
this code in the worksheet module might help...
'----------
Sub MoreClicks()
With Me.Shapes("Check Box 2")
If Range(.ControlFormat.LinkedCell).Value = "True" Then
.TextFrame.Characters.Text = "CLICKED"
Else
.TextFrame.Characters.Text = "off"
End If
End With
End Sub
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Jas" <[email protected]>
wrote in message
I have created a form in excel to link to check boxes but on printing the
checkmark is too small for many to see easily. The check boxes I create in
Word turn out to have a large X through them as default. How can I change
the Excel checkmark to an X or be more legible on printing?