CheckBoxes.Add Works fine in 2010 but not 2007 or 2003

Hello all

i have this code in my macro to create entries in a table and sort the table after. (a name in one column and a checkbox in another)
my code works wonderfully in excel 2010 but when it came to showing my boss who was using MS Office 2003 (tried 2007 with same issue )... excel let me down

Please Login or Register  to view this content.

in 2010 the checkbox is added into the cell and the data with checkbox is sorted no problem. but with office 2003 and 2007 the checkbox is left behind.

side note: i used to have the checkbox created at the bottom of the table which was also the bottom of the sheet (F65536) and it added the checkbox in F644xx or something wrong like that, so i changed it to F100 thinking it would solve the problem and it did not )
any help would be greatly appreciated.
thanks for reading

the checkbox should sort if it is completely contained "within" the parent cell

I have just tested in 2003 and it sorts as required if it fits within F100

PFMEA Creator.zip

Hello, i cannot get this to work. i dont know why it doesent create the checkbox IN/ON the cell i want (F100)
Again this issue only happens in Excel 2003 and 2007.

to reproduce the problem, go to "index" sheet.
Click "Add/Edit/Overwrite PFMEA" button.
give it a random name, (but using a name like HS03 will keep other parts of my code happy although that doesent effect this issue)
Select random cells and press ok.
and you will see that the checkbox was created ABOVE Cell F100 and will not sort with the table.

i also noticed that i cannot get the Height of the checkbox smaller than the cell, even manually (unlike excel 2010 which is flawless)

the code in question in a few lines from the bottom of the VBA window

thanks for your time

you may have to increase the row height of the cells. I can reduce the height of the checkbox to match the range (by resetting the height after adding the checkbox) but then it's not fully legible

try it and see ;-)

btw you will get much better positioning of the controls if you change the window zoom to 100% rather than 145% as it is