Form control - check boxes

[dasadler]

Is there any way to make the check box and text any larger (easier to read)?

[PJ_in_FL]

The text properties (font, font style size, etc.) are easily changed by selecting the Font property in the Properties list for the checkbox. Other properties change the color and alignment of the text. You may need to enable the Properties window by pressing F4 when working in the VBA IDE.

I don't know how to change the size of the checkbox itself.

[HansV]

For the check box from the Form Controls, you can only change the fill color and the line color. Neither the size of the text nor that of the check box can be changed, except by changing the zoom percentage of the window.

PJ is referring to a check box from the ActiveX Controls, or to a check box on a userform.

[Jan Karel Pieterse]

Actually, if you're determined enough, you can use a backdoor to change the font of a forms checkbox anyway:
http://www.jkp-ads.com/articles/excel20 ... rmat01.asp" onclick="window.open(this.href);return false;

[HansV]

Thanks, Jan Karel!

[PJ_in_FL]

For the check box from the Form Controls ...

Oh! Those controls!

[dasadler]

Thanks everyone. I initially inserted the Active X check box but couldn't figure out how to use it in my worksheet. That is, how to use the true/false state in a formula. So... plan B was to use what I have used before.

@Jan Karel Pieterse - Interesting reading.