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?

See if this helps:

http://www.mrexcel.com/board2/viewto...istbox+refresh