software

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?

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 quot;Check Box 2quot; then
this code in the worksheet module might help...
'----------
Sub MoreClicks()
With Me.Shapes(quot;Check Box 2quot;)
If Range(.ControlFormat.LinkedCell).Value = quot;Truequot; Then
.TextFrame.Characters.Text = quot;CLICKEDquot;
Else
.TextFrame.Characters.Text = quot;offquot;
End If
End With
End Sub
--
Jim Cone
San Francisco, USA
www.realezsites.com/bus/primitivesoftwarequot;Jasquot; gt;
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?