View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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