Hi,

I have a very very strange problem which I can not figure out. I wrote some
code a while back which collects a list of data in an array and displays
this array in a list box. It works fine, and still does. I ammened the
code in some of the other module of this workbook, however, this part
remains unchanges. Now the array does not display in the list box unless i
put another window over the list box and move it back - then it appears.
Note, that this can be any other windows, i.e. an instance of internet
explorer etc. It's almost is if the screen has been frozen and needs to
unfreeze. Incidentally, there are another two list boxes on the same
worksheet which are populated with different arrays and they function just
fine. I am using excel 2000. Does anyone have any idea what could be
causing this. Many thanks.

have you turned screenupdating to false in your code?

--
Regards,
Tom Ogilvy


"Graham Whitehead" wrote:

Hi,

I have a very very strange problem which I can not figure out. I wrote some
code a while back which collects a list of data in an array and displays
this array in a list box. It works fine, and still does. I ammened the
code in some of the other module of this workbook, however, this part
remains unchanges. Now the array does not display in the list box unless i
put another window over the list box and move it back - then it appears.
Note, that this can be any other windows, i.e. an instance of internet
explorer etc. It's almost is if the screen has been frozen and needs to
unfreeze. Incidentally, there are another two list boxes on the same
worksheet which are populated with different arrays and they function just
fine. I am using excel 2000. Does anyone have any idea what could be
causing this. Many thanks.