| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
Right click on the box, select "Format Control", and use the Size tab
to alter the dimensions. |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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? |
|
#5
|
|||
|
|||
|
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. |
|
#6
|
|||
|
|||
|
How do I create a small box I can place a check mark in?
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 |
|
#7
|
|||
|
|||
|
How do I create a small box I can place a check mark in?
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 |
|
#8
|
|||
|
|||
|
How do I create a small box I can place a check mark in?
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 |
|
#9
|
|||
|
|||
|
How do I create a small box I can place a check mark in?
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 InsertSymbol, 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a tabular control | Excel Discussion (Misc queries) | |||
| Can't create dynamic charts | Charts and Charting in Excel | |||
| How do I create a macro button and place anywhere on my sheet? | Excel Discussion (Misc queries) | |||
| Can you create a check box or radio button in Excel? | Excel Discussion (Misc queries) | |||
| Using a Check Box as a control item | Excel Discussion (Misc queries) | |||
Linear Mode
