• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to resize checkboxes?

cricket1001

Member
I want to put simple checkboxes in a column that don't relate to any other cell. I want to resize them to be bigger than what they normally are. I have searched and search and can't seem to find how to do this. It seems like such an easy and common thing to do that I find it frustrating that it seems so difficult or impossible to do.
I have inserted a checkbox from the developer tab and deleted the text label. But I can't change the size of the textbox. I've gone into the form control for the checkbox. Under the tab Properties there is an option to Move and size with cells. But it is grayed out and so unusable. I think I might have read somewhere that you can only use that option if you have the checkbox associated with another cell. So I am very frustrated that it seems to be no way to just put simple checkboxes in a column and resize them to the size you want. It is 2019 and with all excel can do it can't make a simple column of checkboxes to be used in lists. Does anyone know a simple solution to this?

Thanks for any help!!!
Sorry if I sound negative. I am just so tired of all the searches and websites I have been to and not being able to find a solution.
 
I also have one checkbox that I can't delete or cut in any way. If I open the control box around it (not sure if that's the right name for it) there are actually 2 checkboxes. I've been able to delete other checkboxes but this one I just can't get rid of. I've gone in the form control and changed everything that could possibly help but that didn't work. Oh, I'm so frustrated with checkboxes. I've wasted so much time with checkboxes and it seems like it should be simple.
 
I agree, the basic form controls look horribly dated and lack meaningful formatting options. I, too, would be interested to see whether anyone has ways of overcoming this, perhaps with Active-X controls. The problem is particularly acute for me because my standard template has a Normal style that introduces a pale grey color fill, which renders standard controls invisible :(.

Tricks that I have adopted include sizing the control to match background cells (Alt+handle drag) and then conditionally format the cells to convey information. For example, state and control cells might contain
State, Control, Color;
Running, Stop, Red;
Stopped, Go, Green.

Other options include giving up on controls and replacing them by shapes with VBA macros to respond to their On-Action property. I only tend to use such devices with 10s of controls. If you have 10s of thousands, I find it better to use the cells themselves and a Selection Change event handler to toggle settings and the visible characteristics of the cell.
 
Back
Top