Listbox data disappearing (from screen only)
 

I have a workbook with an open event that opens another workbook, gets
some data from it, and closes it. The main workbook has a listbox that
is populated from that data. I set ScreenUpdating to false for the
process.

The problem is the list box appears empty when ScreenUpdating is turned
back on. (It's not really empty, if I scroll of the screen and back on
it's all there.) Also, if I don't disable ScreenUpdating, this problem
does not occur.

Why is it doing this and how do I make it stop?

thanks


--
TommySzalapski
------------------------------------------------------------------------
TommySzalapski's Profile: http://www.excelforum.com/member.php...o&userid=25561
View this thread: http://www.excelforum.com/showthread...hreadid=392494