OLEObjects sub called when change in value?

[bs0d]

I have a checkbox with a _click() subroutine.

I also have a command button to effectively reset my form. In this, I set the value of the checkbox to false (unchecked). When I do so, it executes the _click() subroutine.

I tried changing _click() to _change() and it still does the same thing.

What's the best practice for handling checkbox values?

 

[VBA Geek]

SET Application.EnableEvenets = False at the beginning of the code of the command button
before the procedure ends set it back to true

 

[bs0d]

Ahh, very nice. This should make things run a bit more efficient!

Thanks