I have a multi-column activeX listbox on a worksheet. It is linked to a range on another sheet. The values in the listbox do not get updated when the values in the range change.
They do get updated if I switch to a different sheet and back, or otherwise cause the screen to get rewritten.
I have been using a workaround of turning on screen updating, paging the sheet down 1 page and then back up. This had been working (although with undesirable screen flicker) but now has stopped working.
Dooes anyone have another workaround or know if I am missing something that is required to get activeX controls to get updated along wioth the rest of the screen?