changing contents of a combo box

[Iceman10]

when i change the contents of combo box at run time using additem, any code thats in the combo1_click sub gets ran. How do i stop this? any help would be great

[Sam Finch]

Hmm, declare a boolean variable at the top of your form, call it boolStopClickEventRunning

then enclose all the code in your clickevent in an if statement like this

Private Sub Combo1_Click()

If Not boolStopClickEventRunning Then

'your click code here

End If

then when you add an item do it like this

boolStopClickEventRunning = True
Combo1.AddItem MyItem
boolStopClickEventRunning = False

Hope this helps

[Iceman10]

thanx, that did help