I would like to enlarge a checkbox/checkmark to fit my cell.

[Tim Richards]

I would like the actual checkbox to be larger.
I realize I can resize the caption box area.
I'm not currently using the caption area, just the actual textbox.
The worksheet I'm designing has alot of checkboxes and they are to small for
my purpose.

[K Dales]

The box in the checkbox control is not resizable. You can create your own
checkbox fairly easily, though, with a textbox (shape) from the drawing
toolbar. I set the font to be Wingdings 2 and use the "P" character, which
gives a check. The following code set as it's "Assigned Macro" will toggle
it:

Sub TextBox1_Click()
With ActiveSheet.Shapes("Text Box 1").OLEFormat.Object
If .Text = "P" Then .Text = "" Else .Text = "P"
End With
' You can add code here that would be the equivalent of the checkbox's
' _Click, _Change, _BeforeUpdate, or _AfterUpdate event procedures
End Sub

--
- K Dales


"Tim Richards" wrote:

> I would like the actual checkbox to be larger.
> I realize I can resize the caption box area.
> I'm not currently using the caption area, just the actual textbox.
> The worksheet I'm designing has alot of checkboxes and they are to small for
> my purpose.
>