<\/figure>\n\n\n\nThe checkboxes appear bigger and can be accessed easily:<\/p>\n\n\n\n <\/figure>\n\n\n\nMethod 2: Use the Format Control dialog box<\/h3>\n\n\n\n This method does not increase the actual dimensions of the checkbox. It only increases the checkbox\u2019s check area. The increased check area makes it easy to check the checkbox without necessarily having to click inside the checkbox.<\/p>\n\n\n\n
We use the steps below:<\/p>\n\n\n\n
\nRight-click the checkbox and choose Format Control<\/strong> on the shortcut menu.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nIn the Format Control<\/strong> dialog box, check the Lock aspect ratio checkbox. This ensures that the height and width of the checkbox are increased proportionally.<\/p>\n\n\n\nResize the checkbox using the Height<\/strong> and Width<\/strong> spin boxes and click OK<\/strong>.<\/p>\n\n\n\n <\/figure>\n\n\n\nThe checkbox check area is increased:<\/p>\n\n\n\n <\/figure>\n\n\n\nThis means that we can click anywhere in the increased check area to check the checkbox. This can be very helpful for people who have arthritis or other conditions that make it difficult for them to accurately position mouse pointers in the worksheet<\/p>\n\n\n\n
Method 3: Use Excel VBA<\/h3>\n\n\n\n We can use Excel VBA to make symbols that can be resized behave like checkboxes.<\/p>\n\n\n\n
We first need to insert symbols that resemble checkboxes in the worksheet that contains the dataset.<\/p>\n\n\n\n
Insert checkbox symbols<\/h3>\n\n\n\n We use the following steps:<\/p>\n\n\n\n
\nSelect a cell that is outside your dataset. In this case, we select cell E1<\/strong>.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nClick Insert >> Symbols >> Symbols<\/strong>.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nIn the Symbol<\/strong> dialog box, choose Wingdings<\/strong> in the Font<\/strong> drop-down list.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nScroll down the Symbols<\/strong> list and select the symbol that resembles a blank checkbox and click Insert<\/strong>.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nThe symbol is placed in cell E1<\/strong>:<\/p>\n\n\n\n <\/figure>\n\n\n\n\nClick the Close<\/strong> button to close the Symbols<\/strong> dialog box.<\/li>\n\n\n\nSelect cell F<\/strong>.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nOpen the Symbols<\/strong> dialog box as explained previously.<\/li>\n\n\n\nScroll down the Symbols<\/strong> list and select the symbol that resembles a checked checkbox. Click Insert<\/strong>.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nClick the Close<\/strong> button to close the Symbol<\/strong> dialog box.<\/li>\n<\/ol>\n\n\n\nThe symbol of a checked checkbox is placed in cell F1<\/strong>.<\/p>\n\n\n\n <\/figure>\n\n\n\n\nSelect cell E1<\/strong> which contains the blank checkbox symbol and copy the symbol to four more cells by dragging down the fill handle to cell E5<\/strong>.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nCopy a blank checkbox symbol to cell F2<\/strong>.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nCreate Excel VBA Code<\/h3>\n\n\n\n We use the steps below:<\/p>\n\n\n\n
\nIn the active worksheet that contains the dataset, press Alt + F11<\/strong> to open the Visual Basic Editor<\/strong>.<\/li>\n\n\n\nClick Insert >> Module<\/strong> to insert a module.<\/li>\n\n\n\nCopy the following procedures and paste them into the module. Remember to customize them to your requirements.<\/li>\n<\/ol>\n\n\n\nSub resizeCheckbox(ByRef indexVal As String)\n If Range(\"E\" & indexVal).Value = Range(\"F1\").Value Then\n Range(\"E\" & indexVal).Value = Range(\"F2\").Value\n Else\n Range(\"E\" & indexVal).Value = Range(\"F1\").Value\n End If\nEnd Sub\nSub checkBox1()\n Call resizeCheckbox(1)\nEnd Sub\nSub checkBox2()\n Call resizeCheckbox(2)\nEnd Sub\nSub checkBox3()\n Call resizeCheckbox(3)\nEnd Sub\nSub checkBox4()\n Call resizeCheckbox(4)\nEnd Sub\nSub checkBox5()\n Call resizeCheckbox(5)\nEnd Sub<\/code><\/pre>\n\n\n\n\nSave the procedures and save the workbook as a Macro-Enabled Workbook<\/strong>.<\/li>\n\n\n\nRight-click cell E1<\/strong> and choose Copy<\/strong> on the shortcut menu.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nRight-click cell C3<\/strong> and choose Linked Picture<\/strong> on the Paste Special<\/strong> flyout menu.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nUse the resizing handles to resize the symbol.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nWe have resized the symbol:<\/p>\n\n\n\n <\/figure>\n\n\n\n\nClick Picture Format >> Size >> Crop >> Crop<\/strong>.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nRemove unwanted areas from the linked picture.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nThe symbol with the unwanted area removed appears below:<\/p>\n\n\n\n <\/figure>\n\n\n\nRepeat steps 5 to 8 to copy the checkboxes in range E2:E5 to range C4:C7.<\/p>\n\n\n\n <\/figure>\n\n\n\n\nRight-click the checkbox symbol in cell C3<\/strong> and choose Assign Macro<\/strong> from the shortcut menu.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nIn the Assign Macro<\/strong> dialog box that appears, select CheckBox1<\/strong> in the Macro name<\/strong> box and click OK.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\n\nRepeat steps 10 and 11 to assign the remaining macros to the other checkboxes.<\/li>\n\n\n\n Test the checkboxes and see that they work as intended.<\/li>\n<\/ol>\n\n\n\n <\/figure>\n\n\n\nConclusion<\/h2>\n\n\n\n Sometimes we are required to increase the size of the checkboxes in Excel to increase their visibility and accessibility. In this tutorial, we looked at different ways of resizing checkboxes in Excel.<\/p>\n","protected":false},"excerpt":{"rendered":"
Sometimes we may need to increase the size of the checkboxes in Excel to increase their visibility and accessibility. In this tutorial, we…<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[170,190],"yoast_head":"\n
Resize Checkbox in Excel<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n