I know this question has been asked before but I just can't accept that nobody has an answer for this. The check box is TINY. Anyone know how to make the actual check box bigger?
Increase Check Box Size
-
-
Re: Resizing The Check Box???
What check box?
-
Re: Resizing The Check Box???
The check box you create in excel. No matter how big you draw the box the actual box that contains the check mark is tiny.
-
Re: Resizing The Check Box???
What check box?
Is it from the forms toolbar the control toolbox or on a userform?
-
Re: Resizing The Check Box???
Any Sort of Excel Checkbox can be made bigger, so I've no idea why you think you can't.
-
-
Re: Increase Check Box Size
I assume ladydubs is referring to the size of the actual box rather than the control or it's text.
Zooming is the only thing that will change it but it will change everything else as well.
You maybe able to create your own control. Sort of depends on where the control is to be used and how many.
-
Re: Increase Check Box Size
I am speaking of the control toolbox check box. And am referring to the size of the actual box that contains the check mark not where the text is written. I have a form that has two columns of for example BAD and GOOD and check boxes for each row. The box that displays the actual check mark is tiny. I just want to make the check mark in the box bigger and have no idea how to do it.
Sorry for any confusion.
"You maybe able to create your own control. Sort of depends on where the control is to be used and how many."
I don't really know how to go about doing that.
-
Re: Increase Check Box Size
ladydubs
You just can't change the size I'm afraid.
And the only workaround is the zoom.
As to creating your own control, like Andy says that depends on what you are actually doing.:)
-
Re: Increase Check Box Size
How about this?
It uses data validation and customer number format. Use simply select 0 or 1 and a tick is displayed if 1 is selected. No VBA coding required.
-
Re: Increase Check Box Size
Is this what youre looking for? Its a checkbox in Frame. The frame can the be zoomed.
You could probably Hide the Frame if you didnt want the user to see it.
Ger
EDIT: Oddly, it takes a while for this to open. -
-
Re: Increase Check Box Size
Quote from Andy Pope;378312How about this?
It uses data validation and customer number format. Use simply select 0 or 1 and a tick is displayed if 1 is selected. No VBA coding required.
Dear Andy,
It was very useful. Can you kindly explain how to make such a box as well as if we can associate a cross when 0 is selected.
Thanks,
Ans -
Re: Increase Check Box Size
Quote from Ger Plante;378318Is this what youre looking for? Its a checkbox in Frame. The frame can the be zoomed.
You could probably Hide the Frame if you didnt want the user to see it.
Ger
EDIT: Oddly, it takes a while for this to open.Thank you Ger Plante. Brilliant!
-
Re: Increase Check Box Size
glad someone found it useful after all these years
-
Re: Increase Check Box Size
Quote from Andy Pope;378312How about this?
It uses data validation and customer number format. Use simply select 0 or 1 and a tick is displayed if 1 is selected. No VBA coding required.
Oh, buddy, thank you very much !!! It really helped !!!
-
Re: Increase Check Box Size
Thank a lot very helpful
-
-
Thank you Ger Plante. Brilliant!
-
[ATTACH=JSON]{"data-align":"none","data-size":"custom","height":"122","title":"Smile-thumbs-up-clip-art-clipart-image-0.jpg","width":"100","data-attachmentid":1210921}[/ATTACH]
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!