Problem When Setting Checkbox Values

**rcoates** · 06-10-2009, 02:41 AM

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!

**DonkeyOte** · 06-10-2009, 03:33 AM

What you're referring to is the disabling/enabling of Events.

You can for ex. disable events @ Application level before altering the checkbox value such that the change event is not invoked, subsequently enabling events such that going forward clicking it manually does invoke the handler, eg:

Handler:

Private Sub CheckBox1_Click()
MsgBox "Hello"
End Sub

Other Routine to alter Checkbox but not to invoke Handler

Public Sub Example()
Application.EnableEvents = False
CheckBox1.Value = True
Application.EnableEvents = True
End Sub

**rcoates** · 06-10-2009, 06:44 PM

Thank you SO much!
That's very much appreciated :-)

Problem When Setting Checkbox Values

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Problem When Setting Checkbox Values

Re: Problem When Setting Checkbox Values

Re: Problem When Setting Checkbox Values

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions