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!

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

--
HTH

Bob Phillips

"W M" wrote in message
...
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!

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


"Bob Phillips" wrote in message
...
It's not, but it can't be done. See http://tinyurl.com/bfkdt for another
approach

--
HTH

Bob Phillips

"W M" wrote in message
...
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!

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?


"Bob Phillips" wrote in message
...
It's not, but it can't be done. See http://tinyurl.com/bfkdt for another
approach

--
HTH

Bob Phillips

"W M" wrote in message
...
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!

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 wrote:

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?

"Bob Phillips" wrote in message
...
It's not, but it can't be done. See http://tinyurl.com/bfkdt for another
approach

--
HTH

Bob Phillips

"W M" wrote in message
...
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!






--

Dave Peterson

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

I love these forums!


"Dave Peterson" wrote in message
...
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 wrote:

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?

"Bob Phillips" wrote in message
...
It's not, but it can't be done. See http://tinyurl.com/bfkdt for
another
approach

--
HTH

Bob Phillips

"W M" wrote in message
...
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!






--

Dave Peterson