Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing size of check box
Hello,
I'm trying to create a form with a checkbox. I've been able to insert my check box but I'm unable to enlarge it. I've gone to Format - Control - Size but when I change that to a bigger number, the size of the entire Control Box gets bigger with more blank white space but the actual check box (where I check) remains the original size. I've also pulled and dragged the edges of the control but I have the same issue. How do I enlarge the actual check box where users will make their selection? Thanks, Scott |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing size of check box
unfortunately, you can't. both Control Toolbox checkboxes and Forms
checkboxes only come in one size. if that's not good enough, you can make a column & row small and box it in with borders on four sides and use an "x" instead of a checkbox. you could still use this in event macros. :) susan On Apr 1, 11:50*am, Scott wrote: Hello, I'm trying to create a form with a checkbox. I've been able to insert my check box but I'm unable to enlarge it. I've gone to Format - Control - Size but when I change that to a bigger number, the size of the entire Control Box gets bigger with more blank white space but the actual check box (where I check) remains the original size. I've also pulled and dragged the edges of the control but I have the same issue. How do I enlarge the actual check box where users will make their selection? Thanks, Scott |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing size of check box
If the form is worksheet form rather than a VBA userform the checkbox will
resize with the zoom control. Maybe you can use a smaller font but increase the zoom. That will give the appearance of having used the "standard" font size while getting a larger checkbox. -- Biff Microsoft Excel MVP "Susan" wrote in message ... unfortunately, you can't. both Control Toolbox checkboxes and Forms checkboxes only come in one size. if that's not good enough, you can make a column & row small and box it in with borders on four sides and use an "x" instead of a checkbox. you could still use this in event macros. :) susan On Apr 1, 11:50 am, Scott wrote: Hello, I'm trying to create a form with a checkbox. I've been able to insert my check box but I'm unable to enlarge it. I've gone to Format - Control - Size but when I change that to a bigger number, the size of the entire Control Box gets bigger with more blank white space but the actual check box (where I check) remains the original size. I've also pulled and dragged the edges of the control but I have the same issue. How do I enlarge the actual check box where users will make their selection? Thanks, Scott |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check boxe size | Excel Discussion (Misc queries) | |||
Increase size of a Forms Check Box (click on to enter check mark) | Excel Discussion (Misc queries) | |||
How do I increase the size of check in check boxes | Excel Discussion (Misc queries) | |||
check box size | Excel Discussion (Misc queries) | |||
check box size (Not Small Enough) | Excel Discussion (Misc queries) |