The VBA does not work at all for me. When I press F5, it appears that the module runs, but the checkboxes did not move.
-
To post as a guest, your comment is unpublished.After some more experimenting, I figured out that the VBA does work for manually inserted checkboxes, but if I use Kutools batch insert, it does not. How do I center all the checkboxes inserted with Kutools?
-
To post as a guest, your comment is unpublished.Hi quadma,
The code also works for the checkboxes inserted by Kutools. Which Excel version are you using?-
To post as a guest, your comment is unpublished.I'm using office 360. I think the issue that I'm having is that when I use the Kutools batch insert, the size of the the checkbox object is as wide as the column that it's inserted into (i.e. the checkbox object width is greater than it's height), with the visible checkbox itself on being left justified within the object. If I select all the checkbox objects and then resize them so that the height and length are equal, and then run the VBA, it does then center the checkboxes within the column.
This seems like an unnecessary step, given that checkboxes are square, why is Kultools not making the checkbox objects square?
-
To post as a guest, your comment is unpublished.Hi quadma,
The check boxes inserted by Kutools are the same as the Check Box (Form Control) which inserted by Excel.
I don't really understand you said "making the checkbox object square". Normally a check box include the box field and the value field. Kutools keeps the check boxes' value empty if the selected cells are blank. And if there are values in selected cells, the cell value will be taken as the check box value.
-
To post as a guest, your comment is unpublished.I've uploaded a picture to show what I mean. Hopefully that helps.
-
-
-
-