![]() |
Listbox control does not get refreshed
I have a listbox control (not a "form" control) on a sheet. After updating
the ListFillRange setting, the row area of the control is not refreshed. Paging down and back up or changing to a different sheet and back gets the screen to refresh the area within the listbox. It happens with ScreenUpdating on. I have a workaround when i know the box needs to be updated - I set visible to false and then back to true - but it also happens when a form happens to overlap the control. When the form is closed, the portion that overlapped the control is still visible in the control. Another programmer I talked to had the same problem and did not know of any better solution. Is this actually a problem with the contol itself, or am I doing (or not doing) something that creates this problem? Is there a solution that can keep the listbox refreshed without requiring code anytime it might possible be affected by a form? |
All times are GMT +1. The time now is 03:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com