Spurious ComboBox change event

[Tony Adams]

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

 

[Gjones]

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

 

[Tom Ogilvy]

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.