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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 

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

Back
Top