ComboBox Events Fire Many Times
 

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

ComboBox Events Fire Many Times
 

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"ms" wrote in message
...
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

ComboBox Events Fire Many Times
 

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

--
Regards,
Tom Ogilvy



"ms" wrote:

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

ComboBox Events Fire Many Times
 

ActiveX on the worksheet.

--
Regards,
Tom Ogilvy


"Bob Phillips" wrote:

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

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"ms" wrote in message
...
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

ComboBox Events Fire Many Times
 

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

"Tom Ogilvy" wrote in message
...
does your source list for the combobox include cells that contain formulas
and does your change event cause the worksheet to recalculate?

--
Regards,
Tom Ogilvy



"ms" wrote:

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