Thank you Jim.

Then I think I have to use a static variable in the Change event code to
track the previous value of the ComboBox to see whether it is a "real" change
or not, and exit out of the sub in case it isn't.

Thanks
-=Wim=-

"Jim Rech" wrote:

Then I created a dynamic range named MyList =OFFSET(Sheet1!$A$1,0,0,6,1)

I'd guess this is happeneing because OFFSET is a volitile function. Every
time a calculation occurs OFFSET recalcs. So your defined name is recalced
and the combo box takes that as a change event. You might have to live with
this if you want to use OFFSET.

--
Jim