Checkbox position changes as the worksheet zoom changes

Good Afternoon,

I have a bit of code where it places checkbox objects into the worksheet. It's not a user form. What i noticed is that the checkbox position changes as the zoom of the worksheet view changes. Here's my code:

Please Login or Register  to view this content.

Is there a property or method that I am missing? maybe I can modify the address that I'm using to position the checkbox?

Thanks All

My apologies, I searched the forum for the same bug; but, I didn't find any other posts whose issue reflected mine. I'll search again.

But after re-reading my post, I might have not explained the issue in it's most accurate detail. This feature of the spreadsheet is suppose to determine the number of data groups, and add two checkboxes for each data group. There could be anywhere from 1 to 10 data groups. To facilitate this, I added a refresh button. When the refresh button is depressed, VBA determines the number of data groups, and then adds check boxes next to each data group area.

What happens is that the alignment of the checkboxes is good when at 70% zoom. But, the more I zoom in and out, the more skewed the alignment becomes. The checkboxes get skewed vertically, not horizontally. I am not sure what is happening, because I'm setting the alignment of the checkboxes to the cell location.

I'm going to research the forum posts to see if this problem is there, if not can someone provide some insight?

Thanks,
Bob1980

After some more research, I've found a solution. It looks like the Excel OLEObject/FormControls/ActiveXObjects are a little buggy. And, it has something to do with screen resolution.

My work around involves re establishing the position of the checkbox after it is created. So, it's redundant; but, it works.

Please Login or Register  to view this content.

Thanks for the help forum. I'm going to add reputation for everyone that replied.

Thanks!!!!