6StringJazzer
05-26-2017, 07:54 AM
Crossposted at Excel Forum and Stackoverflow but I'm not qualified to post links yet.
I have isolated this problem to the workbook attached. This is from a complex application and I stripped it down to the bare minimum needed to reproduce the problem.
There is one worksheet Labor with a combobox named ComboBoxRatesSelected.
This combobox has a RowSource on sheet Parameters, and it has a LinkedCell on sheet Parameters.
The code module for sheet Labor has an event handler for ComboBoxRatesSelected_Click.
Whenever any change is made to any cell on any worksheet, the event handler is triggered twice. This happens even though the combobox is not clicked, and there is no code that changes the combobox. The only code in the entire workbook is the Click handler for the combobox. The event handler in this version simply puts up a message box.
The only time I have ever seen unintended triggering of an event is if other code changes the value in the control, which will trigger a Click event. However, this stripped-down version rules that out.
I have isolated this problem to the workbook attached. This is from a complex application and I stripped it down to the bare minimum needed to reproduce the problem.
There is one worksheet Labor with a combobox named ComboBoxRatesSelected.
This combobox has a RowSource on sheet Parameters, and it has a LinkedCell on sheet Parameters.
The code module for sheet Labor has an event handler for ComboBoxRatesSelected_Click.
Whenever any change is made to any cell on any worksheet, the event handler is triggered twice. This happens even though the combobox is not clicked, and there is no code that changes the combobox. The only code in the entire workbook is the Click handler for the combobox. The event handler in this version simply puts up a message box.
The only time I have ever seen unintended triggering of an event is if other code changes the value in the control, which will trigger a Click event. However, this stripped-down version rules that out.