Spurious ComboBox change event
 

I have a combobox on one sheet with a VBA routine hadling
the change event. My problem is that thsi event is being
triggered when doing things (other VBA code) on another
worksheet.

Any ideas ????

Thanks

Spurious ComboBox change event
 

Hi Tony;

You did not say which change event you were using but
usually when this happens you need to use a different
event. One that is more constrained to prevent the
unplanned code runs.

Thanks,

Greg


-----Original Message-----
I have a combobox on one sheet with a VBA routine hadling
the change event. My problem is that thsi event is being
triggered when doing things (other VBA code) on another
worksheet.

Any ideas ????

Thanks
.

Spurious ComboBox change event
 

a calculate can cause this if your control is bound to the sheet with
linkedcell or possibly listfillrange.

If you remove these links, the problem should go away.

If that solves the problem, then you can use the Click event to write the
selected value to the cell and in the case of the listfillrange, populate
the combobox with code as well.

--
Regards,
Tom Ogilvy

"Tony Adams" wrote in message
...
I have a combobox on one sheet with a VBA routine hadling
the change event. My problem is that thsi event is being
triggered when doing things (other VBA code) on another
worksheet.

Any ideas ????

Thanks