How To Make A Checkbox Bigger In Excel 2016

• Remove From My Forums

Checkbox Format, How to resize the the checkbox non the frame effectually it

• Question

• oKay folks I haven't used a lot of checkboxes in the by but it seems like this should be like shooting fish in a barrel but I am looking too hard to go information technology.

  I can resize the frame around the checkbox easily enough in the properties but the piddling checkbox remains the aforementioned size unrelated to the frame. How can I alter the actual checkbox?

  Thanks for your help!

  ---

  Chris Ward

Answers

• You might like to take a look at BigCheck.zip in my public databases folder at:

  https://skydrive.alive.com/?cid=44CC60D7FEA42912&id=44CC60D7FEA42912!169

  The 'check boxes' are in fact unbound text boxes with a transparent button over them.  When you click a 'bank check box' you are really clicking the push button, whose lawmaking sets the value of a hidden existent bound check box in the grade.  The frmBigCheckBox_YesNo form gives an example of a simple 'choice group' of 2 'check boxes' only 1 of which tin exist Truthful.

  ---

  Ken Sheridan, Stafford, England

  • Marked as answer by Thursday, February 21, 2013 8:37 PM

• AFAIK, there is no way to practice this. At to the lowest degree, I've been looking for a whole day but without any success. If information technology exists, it would be smashing to hear from someone who knows.

  ---

  Andrey Five Artemyev | Saint-Petersburg, Russian federation
  Russian blog artemyev.biztoolbox.ru
  

  • Marked as answer past KCDW Thursday, Feb 21, 2013 viii:37 PM

• Chris,

  From my research in the by I believe that Microsoft has not programmed the checkbox to be able to be resized. At that place are some different option you can do which involve creating your own bank check box using some VBA and either a listbox or textbox with wingdings. It requires a lot more work than just calculation a check box, just can be washed. I take never attempted this because I decided against the extra try, but you tin find many examples on the spider web.

  Ben

  • Marked as answer past KCDW Thursday, February 21, 2013 eight:37 PM

• Thank you everyone,

  Ken cheers for your Demo I was able to realize from it all I needed to practice for my needs is take on the Report a Textbox Formatted to Wingdings and the Command Source set to the Checkbox hidden, with this lawmaking;

  =IIf([FMLA],Chr(252),"")

  So whatever is in the Record'due south checkbox will show on the Written report with the textbox formatted to Wingdings checked or empty. Nice!

  Thank you!!!

  ---

  Chris Ward

  • Marked as answer past KCDW Thursday, February 21, 2013 8:42 PM

Source: https://social.msdn.microsoft.com/forums/office/en-US/815e252c-e3ef-4ab7-b2f2-a388db63368b/checkbox-format-how-to-resize-the-the-checkbox-not-the-frame-around-it

Posted by: wisdomaboaccon.blogspot.com

Share this post