ComboBox Events Fire Many Times

  • Thread starter Thread starter ms
  • Start date Start date
M

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
 
What sort of combobox, userform, worksheet activex controls, or worksheet
forms?

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
does your source list for the combobox include cells that contain formulas
and does your change event cause the worksheet to recalculate?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

active combobox - possible to configure as display value andcoordinate value? 3
Class Raise Event not firing 3
Combobox_change event fires when a workbooks is saved 3
sheet event wait for another event? 6
UserForm Combobox Change Event 4
Combobox_Change event fires on workbook close 3
combobox change fires on workbook close when textcol <>1 or -1 2
combo box change event 3

Back
Top