Unusual Behavior of Combo Box not Updating

[bisel]

Hello All,

I am noticing something strange ...

I have a workbook with several sheets. I have a combo box on two of the sheets. Each combo box points to the same linked cell and each has the same linked range. Sheet1 has the linked cell and one of the combo boxes. Sheet2 has the other combo box only. When I update one of the combo boxes, the other updates just fine as does the value of the linked cell. However, if I manually change the value of the linked cell, the combo box on that Sheet1 updates as it should, but the combo box on Sheet2 does not update unless I activate the sheet a couple of times or restart Excel. If I perform a manual calculation, no change. Normally, the user would not update the linked cell directly, but I sometimes would access the linked cell directly using a macro to make a value change. I would like BOTH combo boxes to update their value (and display) accordingly. Right now, if I update the linked cell, only one of the combo boxes updates. The other remains stuck on the previous value.

Any thoughts?

Regards,

Steve

 

[Artik]

Instead of a connection between the cell and the control, use the Change control event.

Artik