Home |
Search |
Today's Posts |
#1
|
|||
|
|||
check box size
Is there a way to change the size of a checkbox? I am working in a
spreadsheet that will not allow me to change the size of the box itself. Thanks as always for your help! Mark |
#2
|
|||
|
|||
check box size
You could cheat, and use a label.
From the control toolbox, draw a label and set its BorderStyle to 1 - fmBorderStyleSingle. Set its font to Wingdings and set its font size to whatever best fits inside the label. Give the label the following code in VBA: Private Sub Label1_Click() If Label1.Caption = "ü" Then Label1.Caption = "" Else Label1.Caption = "ü" End If End Sub (if you have named the label something different then subsitute Label1 with whatever you named it). If you use this method, then, when referencing the label in code, if Label1.Caption = "ü" then it's ticked, otherwise it's not ticked. However, if you use this method, you cannot use the keyboard to operate it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Font Size in Check Box | Excel Discussion (Misc queries) | |||
check box size (Not Small Enough) | Excel Discussion (Misc queries) | |||
Customize page size | Setting up and Configuration of Excel | |||
Forms Check Box Font Size | Excel Discussion (Misc queries) | |||
check box formatting | Excel Discussion (Misc queries) |