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)

"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

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

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

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