alita
03-11-2009, 03:29 AM
Hi all,
I have the following problem and couldn't find anything in this forum and with Google which would help me:
How can I avoid that when I set the value of a CheckBox or an OptionButton to true in the programm code the Click-Event of this CheckBox / OptionButtons is called?
To explain it a little further: I have a worksheet with OptionButtons and CheckBoxes on it. Now I have one line in the program code for the Click-Event of the CheckBox that under certain circumstances, the value of the OptionButton is set true and vice versa.
At Microsoft's MSDN I found out that the Click-Event of a CheckBox / OptionButton is called everytime the value of it gets set to true. But that makes my program canceling with errors in the end. So I somehow have to avoid that the Click-Procedure is called when the value of an OptionButton / CheckBox is set to true in the program code or I need another event (instead of "Click") under which I can put my program code.
Does anyone have any ideas, please?
I have the following problem and couldn't find anything in this forum and with Google which would help me:
How can I avoid that when I set the value of a CheckBox or an OptionButton to true in the programm code the Click-Event of this CheckBox / OptionButtons is called?
To explain it a little further: I have a worksheet with OptionButtons and CheckBoxes on it. Now I have one line in the program code for the Click-Event of the CheckBox that under certain circumstances, the value of the OptionButton is set true and vice versa.
At Microsoft's MSDN I found out that the Click-Event of a CheckBox / OptionButton is called everytime the value of it gets set to true. But that makes my program canceling with errors in the end. So I somehow have to avoid that the Click-Procedure is called when the value of an OptionButton / CheckBox is set to true in the program code or I need another event (instead of "Click") under which I can put my program code.
Does anyone have any ideas, please?