Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Finding window handle of data validation listbox | Excel Programming | |||
UserForms:listbox display problems | Excel Programming | |||
Multicolumn ListBox in Userforms (selecting specific rows) | Excel Programming | |||
Moving cell values from sheet2 to sheet1 using UserForms and ListBox | Excel Programming | |||
Userforms - listbox question | Excel Programming |