How do I change a check box checkmark to an X

G

Guest

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?
 
J

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do you change colors/fonts on a check box 2
How do I set up a checkmark box in Excel? 1
how do I increase the actual size of a checkmark box in excel 2
How do I insert a checkmark into an excel spreadsheet? 10
How do I get a field in excel to auto complete with a check mark 1
How do I create checkmark boxes in Word? 3
How do I access the read-only box on my disc? 2
Insert Check Box 2

Top