Forum Discussion
Excel v16.63.1 for Mac - insert checkbox
I'm running Excel on a Mac (macOS Monterey, ver 12.5). I'm adding checkboxes to my spreadsheet but cannot find a way to adjust the size of the checkbox itself. The Move and size with cells is graye...
There was a time in the distant past where you could format checkbox and other controls for font, color, shading, etc. Microsoft decided to simplify the controls years ago.
You can make your own checkbox control using a shape and use VBA to set a font to a check box when the shape is clicked. It's a little more work, but you get to fully format the shape and even the checkmark.
You can make your own checkbox control using a shape and use VBA to set a font to a check box when the shape is clicked. It's a little more work, but you get to fully format the shape and even the checkmark.
Thank you JimGMac. I forgot how difficult it is to use Microsoft products...I got so used to Keynote and Numbers that when I jump back to Excel, & Powerpoint, it's like going backwards 15years.
Hi again,
Changing font size and characteristics is pretty much the same across the board. If you use a font character you can control its size and color very easily.
You can probably use a cell formula or conditional formatting to turn the check box on or off. You probably don't need a macro at all.