Hello,

I'm using Excel 97 and in project I use a userform with a listbox.
First I get the different values for the listbox from a database and I
put them on the worksheet. Ok, first time I run it, there is no
problem, the values appear in the listbox. But now when I re-run
auto-open, there appear empty values in the listbox, although the
worksheet shows again the values from the database.
If I run the code again trough the debug mode, one line at a time,
then nothing goes wrong???? What is wrong? I hope anyone can help
me.

Thanx in advance

Bart