Center aligning checkboxes when generating via VBA

Hi guys,

I am generating several checkboxes onto a workbook I have via VBA, but the issue I'm having is that the checkboxes are not aligning to the centre of the cells.

I was hoping someone could point me in the right direction with this. I have included a simple version of the code I am using to generate the checkboxes, and any help with aligning them to the center automatically would be much appreciated!

Thanks

Please Login or Register  to view this content.

Hmm.. thought I had figured it out by offsetting the Left value, but it's not a perfect solution... if someone can still help me with code to center it perfectly in the middle of the cell (both horizontally and vertically) it would be much appreciated.

You made the checkbox the same size as the cell so centering would not give the appearence you are after.

try this.

Please Login or Register  to view this content.