Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel CheckBox on UserForm Event Loops
Hi,
I have created an Excel UserForm with multiple checkboxes. I am noticing some strange behavior in that this control keeps firing the Click / Change Event every time I change the controls.value property - enn in other code. I did notice a support article stating this on MSDN after much pulling hair. I am wondering if anyone out there has had this happen and am wondering how you got around it. Currently, I have public variables set to bypass the event code, but I would think there is a better way. Example: sub chkbox1.Change() Set_Control() end sub chkbox2.Change() Set_Control() end .... sub Set_Control Use tabindex to also set values for other check boxes in different frames. other.value = True (or false) end sub I notice that the change event fires again after set control which then initiates Set Control again. It doesn't cause an endless loop but fires routine twice. Anyone have any ideas? A relatively simple userform has taken days to get the controls to work right because of this issue. Thanks -- ptnagle |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel CheckBox on UserForm Event Loops
Vraiables is the standard way
sub chkbox1.Change() Static FControl As Boolean If Not fBoolean Then fBoolean = True Set_Control fBoolean = False End If End Sub -- HTH RP (remove nothere from the email address if mailing direct) "ptnagle" wrote in message ... Hi, I have created an Excel UserForm with multiple checkboxes. I am noticing some strange behavior in that this control keeps firing the Click / Change Event every time I change the controls.value property - enn in other code. I did notice a support article stating this on MSDN after much pulling hair. I am wondering if anyone out there has had this happen and am wondering how you got around it. Currently, I have public variables set to bypass the event code, but I would think there is a better way. Example: sub chkbox1.Change() Set_Control() end sub chkbox2.Change() Set_Control() end ... sub Set_Control Use tabindex to also set values for other check boxes in different frames. other.value = True (or false) end sub I notice that the change event fires again after set control which then initiates Set Control again. It doesn't cause an endless loop but fires routine twice. Anyone have any ideas? A relatively simple userform has taken days to get the controls to work right because of this issue. Thanks -- ptnagle |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checkbox Event | Excel Discussion (Misc queries) | |||
Click Checkbox Event | Excel Programming | |||
Change Event that Loops | Excel Programming | |||
Excel VBA - Userform Checkbox/Textbox Problem | Excel Programming | |||
CheckBox Event | Excel Programming |