Check Boxes Formatting is off, does not always show up in the right cell

[NumbersGeek]

We have a checklist document that has check boxes formatted in for yes and no. Many times these boxes appear out of format or even have multiple check boxes in one yes box but none in the no. I'm not sure where to start to fix this? Row 32/33 is an example on the phase 2 page.

[LJMetzger]

Hi NumbersGeek,

My speculation is that you are using 'Active X' CheckBoxes and there may or may not be hidden rows involved.

'Active X' controls don't seem to play nicely with others. Whenever I have to use 'Active X' controls, I create them using VBA to minimize the pain. When there is a corruption, it is relatively easy to fix the problem.

Most of the time the corruption manifests itself as a height of 0 (ZERO) and/or the Left and/or Top coordinates have been moved. If you have to use 'Active X' a VBA routine called from Workbook_Open() can often fix the problem if you know the names, and Top,Left,Width, Height of the 'Active X' controls.

I try to avoid 'Active X' controls in favor of Shapes, Forms Controls, or UserForms.

I hope this helps.

Lewis