| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
EnableEvents doesn't work
Now it works nicely, thanks!
Stefi Stefi ezt *rta: Many thanks, Dave and Norman for your quick responses, I'll try that way! Stefi Dave Peterson ezt *rta: This isn't an event to excel. So you have to take care of it yourself. Are these controls from the control toolbox toolbar placed on a worksheet? If you're calling the _click event from a procedure in a general module, you can use: Option Explicit Public blkproc As Boolean Sub testme() blkproc = True Sheet1.CheckBox1.Value = False blkproc = False End Sub Then in the worksheet module: Option Explicit Private Sub CheckBox1_Change() If blkproc = True Then Exit Sub MsgBox "Change" End Sub Private Sub CheckBox1_Click() If blkproc = True Then Exit Sub MsgBox "Click" End Sub (I usually use _change.) Stefi wrote: Hi All, I have a checkbox with a CheckBox_Click event. In some cases I want to change the value of its linked cell (to FALSE) through VBA, and in these cases I don't want to run CheckBox_Click event code. I set Application.EnableEvents to FALSE before changing the linked cell value, but event code is still executed. How can I avoid it? Thanks, Stefi -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Application.EnableEvents | Excel Worksheet Functions | |||
| EnableEvents BeforeClose | Excel Programming | |||
| application.EnableEvents | Excel Discussion (Misc queries) | |||
| EnableEvents=False doesn't work? or does it? | Excel Programming | |||
| application.enableEvents | Excel Programming | |||
Threaded Mode
