Hello,

This is my first post, I hope someone can help me :-)

I have created some activex checkboxes on a worksheet.

When they are ticked (or unticked), a function is called. For example if the checkbox name was "ManualCharging", it calls a function ManualCharging_Click()

That's fine.

The only issue is that at times I would like (elsewhere in my VBA code) to change the value of "ManualCharging" using the code line ManualCharging.value = false, but without calling the click function ManualCharging_Click(). I want that one to only be called when a user actually uses the mouse to tick or untick the checkbox.

Is there any way to do that? Is there another call besides ManualCharging.value = false to do that?

I've managed to work it so my project still works even with this unwanted effect, it's just that it's not very efficient because lines of code are being called that aren't required - esp. for some checkboxes which in turn call other functions with nested loops etc.

Thanking you all kindly in advance!