Changing size of check box

S

Scott

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
 
S

Susan

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
 
T

T. Valko

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


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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top