Checkbox Resizing

[W M]

Windows XP
Office XP

I wonder if there is a way to resize checkboxes in Excel? I want the square
checkbox to be bigger than the default size. Hope this is not a stupid
question!

 

[Bob Phillips]

It's not, but it can't be done. See http://tinyurl.com/bfkdt for another
approach

 

[W M]

That is precisely what I needed, Bob. Thanks for sharing your knowledge and
help.

 

[W M]

Hi again Bob,

Your programming solution to resizing checkboxes is wonderful. Thus far, I
have not been able to make it work on merged cells, however. Is this
possible?

 

[Dave Peterson]

I'm not sure which version of Bob's code you're using, but there's a portion
that looks like:

With Target
If .Value = "a" Then
.Value = ""
Else
.Value = "a"
.Font.Name = "Marlett"
End If
End With

Change that top line to:
With Target.Cells(1)

To see if that helps.

 

[W M]

Thank you Dave, that did the trick, and I am much obliged to you.

I love these forums!