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)

"ms" <ben.crinion@nospam.ultimedia.co.uk> wrote in message
news:e02CsH3bGHA.2068@TK2MSFTNGP02.phx.gbl...
> 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 Ogilvy]

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
>
>
>

[Tom Ogilvy]

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" <ben.crinion@nospam.ultimedia.co.uk> wrote in message
> news:e02CsH3bGHA.2068@TK2MSFTNGP02.phx.gbl...
> > 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
> >
> >
>
>
>

[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

"Tom Ogilvy" <TomOgilvy@discussions.microsoft.com> wrote in message
news:98EE3360-65E9-4336-B892-BCC505157F22@microsoft.com...
> 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
>>
>>
>>