T
Tim
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?
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?