Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jas
 
Posts: n/a
Default How do I change a check box checkmark to an X

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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Cone
 
Posts: n/a
Default How do I change a check box checkmark to an X

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"
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?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Event Macro adjustment needed - need to change font color also nick s Excel Worksheet Functions 2 November 28th 05 05:50 PM
Can you sort with check boxes? Q Excel Discussion (Misc queries) 3 November 10th 05 08:11 PM
Cell Change Color - Need Help alani New Users to Excel 3 June 29th 05 03:50 PM
change cell shading whenever contents different from previous cell zooeyhallne Excel Discussion (Misc queries) 3 June 6th 05 09:59 PM
conditional cell shading when a change occurs zooeyhall Excel Discussion (Misc queries) 1 June 6th 05 05:14 PM


All times are GMT +1. The time now is 12:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"