How do I create a small box I can place a check mark in?

I can copy and paste a large box that I can click and the the pointing finger
comes up and places a check mark in it, but it's too big, how can I create a
smaller box that I can do the same thing to?

Right click on the box, select "Format Control", and use the Size tab
to alter the dimensions.

I should mention the one I can cut and paste is in a text box and altering
the size just alters the size of the text box itself not the check box inside.

"PAM" wrote:

> I can copy and paste a large box that I can click and the the pointing finger
> comes up and places a check mark in it, but it's too big, how can I create a
> smaller box that I can do the same thing to?

I should mention the one I can cut and paste is in a text box and altering
the size just alters the size of the text box itself not the check box inside.


"Dave O" wrote:

> Right click on the box, select "Format Control", and use the Size tab
> to alter the dimensions.
>
>

I am able to do the checkbox with the forms toolbar and also the Toolbox
toolbar, but I can't make it any larger - it only stays one size. Can you
help me?

"Excel_Geek" wrote:

>
> Have you tried the checkbox form in the Forms toolbar?
>
> View --> Toolbars --> Forms
>
> Click the checkbox form and click, drag to size, and release it in the
> worksheet where you need it. You can resize the text handle down to
> near nothing and delete the text in it, too.
>
> Is this small enough?
>
>
> --
> Excel_Geek
>
>
> ------------------------------------------------------------------------
> Excel_Geek's Profile: http://www.excelforum.com/member.php...o&userid=26423
> View this thread: http://www.excelforum.com/showthread...hreadid=397282
>
>

You can't change the size of the checkbox control from the Forms toolbar
or the Control toolbox.

Ladybug726 wrote:
> I am able to do the checkbox with the forms toolbar and also the Toolbox
> toolbar, but I can't make it any larger - it only stays one size. Can you
> help me?
>
> "Excel_Geek" wrote:
>
>
>>Have you tried the checkbox form in the Forms toolbar?
>>
>>View --> Toolbars --> Forms
>>
>>Click the checkbox form and click, drag to size, and release it in the
>>worksheet where you need it. You can resize the text handle down to
>>near nothing and delete the text in it, too.
>>
>>Is this small enough?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Can you tell me how I can make a checkbox that I can size?

"Debra Dalgleish" wrote:

> You can't change the size of the checkbox control from the Forms toolbar
> or the Control toolbox.
>
> Ladybug726 wrote:
> > I am able to do the checkbox with the forms toolbar and also the Toolbox
> > toolbar, but I can't make it any larger - it only stays one size. Can you
> > help me?
> >
> > "Excel_Geek" wrote:
> >
> >
> >>Have you tried the checkbox form in the Forms toolbar?
> >>
> >>View --> Toolbars --> Forms
> >>
> >>Click the checkbox form and click, drag to size, and release it in the
> >>worksheet where you need it. You can resize the text handle down to
> >>near nothing and delete the text in it, too.
> >>
> >>Is this small enough?
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>

If you need a working checkbox, the only two available in Excel are the
ones from the Forms toolbar or the Control toolbox, and they can't be
resized.

If you need a checkbox you can print, you could use the rectangle tool
from the Drawing toolbar, to create one.
Or, choose Insert>Symbol, and choose the Wingding font.
At the end of the list is a checkbox with check mark.

Ladybug726 wrote:
> Can you tell me how I can make a checkbox that I can size?
>
> "Debra Dalgleish" wrote:
>
>
>>You can't change the size of the checkbox control from the Forms toolbar
>>or the Control toolbox.
>>
>>Ladybug726 wrote:
>>
>>>I am able to do the checkbox with the forms toolbar and also the Toolbox
>>>toolbar, but I can't make it any larger - it only stays one size. Can you
>>>help me?
>>>
>>>"Excel_Geek" wrote:
>>>
>>>
>>>
>>>>Have you tried the checkbox form in the Forms toolbar?
>>>>
>>>>View --> Toolbars --> Forms
>>>>
>>>>Click the checkbox form and click, drag to size, and release it in the
>>>>worksheet where you need it. You can resize the text handle down to
>>>>near nothing and delete the text in it, too.
>>>>
>>>>Is this small enough?
>>>
>>
>>--
>>Debra Dalgleish
>>Excel FAQ, Tips & Book List
>>http://www.contextures.com/tiptech.html
>>
>>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html