Multiple Userforms/Listbox in VBA window
 

STrange. I have a VBA program with 3 Userforms, each with a listbox. I got
one program to run perfectly. I created 2nd program using same forms and
boxes. The 1st listbox works fine. The 2nd listbox doesn't stay open. It
immediately closes without letting me select an item. Now I have the same
problem with the 1st program.

Stepping through the code it work ok. Seem like it is not clearing the
previous selection. Even though it doesn't open, the listbox has a good
listbox2.value.

I'm running with excel 2003 sp2


First list box I add only two values. The 2nd listbox has 44 items. I'm
running with excel

Multiple Userforms/Listbox in VBA window
 

Found my own solution. Added 1 secon delay before openning each listbox.
Crude fix, but it works.

"Joel" wrote:

STrange. I have a VBA program with 3 Userforms, each with a listbox. I got
one program to run perfectly. I created 2nd program using same forms and
boxes. The 1st listbox works fine. The 2nd listbox doesn't stay open. It
immediately closes without letting me select an item. Now I have the same
problem with the 1st program.

Stepping through the code it work ok. Seem like it is not clearing the
previous selection. Even though it doesn't open, the listbox has a good
listbox2.value.

I'm running with excel 2003 sp2


First list box I add only two values. The 2nd listbox has 44 items. I'm
running with excel