I have a msforms.listbox on a userform and I wrote code to sort rows of the
list by column when I click a column heading. There are a few problems that
I found by googling such as column headers are broken and they must be
created with labels on top of the list box but my code works. For a large
table of several thousand rows I want to tell the user to "Wait" by changing
the caption of a label on the form and then sorting but I found that the
caption changes after the sort completes rather than before. I have code
lines to change the caption and call my sort function consecutively. If I
single step the lines the caption changes first but when I execute normally
the caption changes last.

My hypothesis is that underneath the hood there must be Windows message
passing going on and it looses a race to the start of my sort function which
presumably dominates the interpreter unit it completes. How can I insure
that the label caption will change first?

LA

Have you tried refreshing the form (using Me.Repaint) after changing the
label ?

Tim


"Luke Alcatel" wrote in message
...
I have a msforms.listbox on a userform and I wrote code to sort rows of the
list by column when I click a column heading. There are a few problems
that
I found by googling such as column headers are broken and they must be
created with labels on top of the list box but my code works. For a large
table of several thousand rows I want to tell the user to "Wait" by
changing
the caption of a label on the form and then sorting but I found that the
caption changes after the sort completes rather than before. I have code
lines to change the caption and call my sort function consecutively. If I
single step the lines the caption changes first but when I execute
normally
the caption changes last.

My hypothesis is that underneath the hood there must be Windows message
passing going on and it looses a race to the start of my sort function
which
presumably dominates the interpreter unit it completes. How can I insure
that the label caption will change first?

LA

Thanks - that works. I had not known of the repaint function.

"Tim Williams" <timjwilliams at gmail dot com wrote in message
...
Have you tried refreshing the form (using Me.Repaint) after changing the
label ?

Tim


"Luke Alcatel" wrote in message
...
I have a msforms.listbox on a userform and I wrote code to sort rows of
the
list by column when I click a column heading. There are a few problems
that
I found by googling such as column headers are broken and they must be
created with labels on top of the list box but my code works. For a
large
table of several thousand rows I want to tell the user to "Wait" by
changing
the caption of a label on the form and then sorting but I found that the
caption changes after the sort completes rather than before. I have
code
lines to change the caption and call my sort function consecutively. If
I
single step the lines the caption changes first but when I execute
normally
the caption changes last.

My hypothesis is that underneath the hood there must be Windows message
passing going on and it looses a race to the start of my sort function
which
presumably dominates the interpreter unit it completes. How can I
insure
that the label caption will change first?

LA