Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2004

    Unanswered: Listbox doesn't get updated

    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?

  2. #2
    Join Date
    Oct 2003
    old, slow, and confused
    but at least I'm inconsistent!

    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts