View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default display problem with listbox

Have you actually isolated the problem to being a graphic repaint problem and
not a problem with the function to sort the data? It is difficult to analyze
without seeing the relative code.

"Luke Alcatel" wrote:

I use an MSForms ListBox and I've implemented functions to sort the rows
according to column values when I click on a column header. I have found
that after sorting, the displayed rows are in correct sort order but rows
that were scrolled out of view often are not, i.e. those rows are not
repainted. I tried a repaint in the scroll event handler but this did not
correct the problem. How can I force the needed graphical rendering update?

Luke