ComboBox Events Fire Many Times

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
 
B

Bob Phillips

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)
 
T

Tom Ogilvy

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

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
 

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
Copy Sheet causes Combo Box change event to fire on original sheet 0
ProjectBeforeTaskChange doesn't fire on field clear 0
combobox change fires on workbook close when textcol <>1 or -1 2
Disable all Control Events on a Userform when it is Intialized 1
Is there an AfterUpdate event for excel combobox? 1
MsgBox in Enter event causes combobox not to run Change event 0

Top