ComboBox Events Fire Many Times

[ms]

Hi

My ComboBox events fire mutiple times for no apparant reason.

The Change event fires 3 times when i change the value, the Click event also
fires 3 times aswell. The events fire countless times when i save the work
sheet and it fires events for other controls on the worksheet aswell.

Does anyone know whats going on and how to fix this problem? I am not
changing the selected item in the combobox in the change event handler just
reading the value.

Thanks
Ben Crinion

 

[Bob Phillips]

What sort of combobox, userform, worksheet activex controls, or worksheet
forms?

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

 

[Guest]

does your source list for the combobox include cells that contain formulas
and does your change event cause the worksheet to recalculate?

 

[Guest]

ActiveX on the worksheet.

 

[ms]

Tom

I was getting the data from a range on another worksheet and it must have
been rebinding to the range which was causing the events to fire.

Thanks for your pointer.

Ben