Unusual Behavior of Combo Box not Updating

bisel

Active Member
Joined
Jan 4, 2010
Messages
264
Office Version
  1. 365
Platform
  1. Windows
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
 
Instead of a connection between the cell and the control, use the Change control event.

Artik
 
Upvote 0

Forum statistics

Threads
1,226,771
Messages
6,192,924
Members
453,767
Latest member
922aloose

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top