Multiple Userforms/Listbox in VBA window

J

Joel

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
 
J

Joel

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top