Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Event Macro adjustment needed - need to change font color also | Excel Worksheet Functions | |||
Can you sort with check boxes? | Excel Discussion (Misc queries) | |||
Cell Change Color - Need Help | New Users to Excel | |||
change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) | |||
conditional cell shading when a change occurs | Excel Discussion (Misc queries) |