ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Listbox control does not get refreshed (https://www.excelbanter.com/excel-programming/323089-listbox-control-does-not-get-refreshed.html)

Tim

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