Active X Checkboxes keep resizing

I found this to be the case if the checkboxes when originally placed on the sheet touched or slightly overlapped cell boundaries.
When initially placing ensure totally contained in cell and slightly smaller than cell.
In the distant past I plagiarised the attached code from a website (i cannot remember ?????)
I have used it on many occasions and never experienced further problems.
It works for both 'Form' & 'ActiveX' used on sheets - Form checkboxes in col 'A' - ActiveX in col 'I'
Hope this helps.
torachan.

You're better off not using ActiveX controls on worksheets at all. They're incredibly unstable have a look here https://www.google.co.uk/webhp?sourc...eet%20controls and by using them, you're asking for trouble.

Forms controls are much more reliable - they're in the same dropdown as the ActiveX ones, but are designed for use on worksheets - so you don't run into any stability issues, you can do most of the same things with them too and you can use them without using code.

Yeah i know but with the form controls i can only assign a macro to it when you check the checkbox. I need 1 macro when checked and 1 macro when unchecked.

Just run the same macro and check whether it is ticked

Well i added an excel sheet to show my problem. If you have another sollution that would be awesome. But 2 checkboxes(1 for highlight and 1 for remove highlight is no option because in the real spreadsheet there is no space left.)

There's no code in that workbook, however, I'm not sure why you'd need 2 checkboxes, consider:

Please Login or Register  to view this content.

Though you could do it with conditional formatting of course and skip the macros altogether

Does conditional formatting work with checkboxes?

Yes, you base it on the linked cell

That would be an option but it is too much work. There are over 500 cells to be formatted

How is a macro less work?

Can you post the code you have?

I was NOT actively recommending ActiveX checkboxes.
Just stating that the only time I have had a problem is when they are not cell contained.
Looking at Afjio12 sheet the checkbox is randomly 'plonked' on the sheet, is it a case of a self-inflicted problem.
Indeed since discovering this even if I use ComboBoxes or Command buttons on a sheet I always contain them within a cell.
Although my preferred approach where ever possible is to use the 'UserForm' for any VBA interface.
torachan.

@Kyle123,

The only code i have is the code withing the checkbox to call the macro's.

@torachan,

In my real workbook i placed the checkboxes within a cell and the problem still occurs. I now see that you need to avoid using axtive x controls but i just can't get two macro's assigned to 1 userform checkbox

That you still haven’t posted....

It’s less code to use forms controls than active controls

Without posting your code, you aren’t going to get an answer

I have no idea why but the code and macro's disapeared in my workbook. I uploaded a new one in my original post. Sorry for the confusion

Ah that's awesome i didn't know that was possible. Tx!

Glad you got it sorted, thanks for the rep