Change checkbox value
There may be easier ways (consider testing "application.events = false"
before you change the checkbox, and "application.events = true" immediately
after, that might work?)
but for straight (if inelegant) logic, add another variable
Sub Checkbox_Change
If MyVariable = True then
'all the code here
end if
End sub
Sub MyOtherProcedure
MyVariable = False
CheckboxA = True
CheckboxA = False
MyVariable = True
end sub
Of course, you will need to set MyVariable to True in the workbook_open
event, to make sure it is always enabled unless you decide to disable it. I
think an uninitialized variable will have a null value, so maybe you could
use that to your advantage, but again, I haven't tested that in actual use.
HTH,
Keith
"mooresk257" wrote:
Hi,
So, on to my next dilemma - how do I change the value of a check box without
initiating a Checkbox_Change sub attached to it?
I have a check box (Sheet1.CheckBox1.Value = True) and changing the value to
false triggers the change event sub whether the check box is enabled or not.
It does not seem to matter if it is a Checkbox_Click() or Checkbox_Change()
event.
Any suggestions?
Thanks!
Scott
|