ActiveX combobox click triggers unwanted another comboxbox click event

I think there is a typo in your description or your code...
One says Sheet2.Range("b2")=me.cbo2.value
The other says Sheet2.Range("B1") = Me.cbo2.Value
Not that either one is the problem.
Not seeing anything that would cause ComboBox1 to trigger when clicking/changing ComboBox2, unless 1 is dependent on 2.

sheet2.Range("A1") = Me.cbo1.value

If cbo1 is populated by its .ListFillRange property and that list-range includes cell Sheet2.Range("A1") , then writing to a cell in its list-range will trigger cbo1 to re-populate and in turn trigger it's _Click event.

AlhpaFrog: Yes cbo1 listfillrange is set in its property to a namerange((it's on sheet1). It doesn't include cell sheet2.range("A1"). Somehow it still triggers cbo1 click...I tried enableEvents but it didn't work

Tom: cbo2 is dependent on cbo1, when cbo1 equals certain value cbo2 populates with corresponding values.

Originally Posted by aprildu

AlhpaFrog: Yes cbo1 listfillrange is set in its property to a namerange but it doesn't include cell sheet2.range("A1") (it's on sheet3). Somehow it still triggers cbo1 click...I tried enableEvents but it didn't work

Is the named range for the List on Sheet2 as well? If yes, then as a test, write the cbo values to a different sheet.

You are correct in that EnableEvents has no effect on controls.

I just found out that I made an error in my original code. The name range for cbo1 is on sheet1 and cbo2 added items are also on sheet1. But I typed in sheet5 instead (in my original file that didn't work not the sample code above). Still it's strange why it would trigger the cbo1 click event. Thanks AlphaFrog you are always a lifesaver!

Are you using any RANDOM (RAND) formulas anywhere? Or, do you have a Worksheet_Change event code that you are using?

Been there, now I'm bald!

I'm am not familiar enough with coding a ComboBox in the manner that you have, so any info/suggestions I provide might be level 1 rookie stuff that makes no sense. Such as....List 1 and 2 are being set to = New Collection. Could this be causing the problem as they are both set to the same thing so one triggers the other?

I think it's the dynamic range for cbo1 1 listfillrange that's triggering cbo1 click event. I tried it in a clean book (to eliminate other possible errors). It worked fine with a static name range until I changed to dynamic range. Don't know why but excel does 'strange things' once in awhile anyways. I resorted to populate cbo1 the same way (collection) as cbo2 and cbo3. It's working now finger crossed. And I am not touching/changing this block anymore lol.

lol, good luck. This might be a good reason for me to stick to naming the range in the Row Source of the properties window. keeps me from having to figure out the code I need (and the issues that go along with it).