LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9,101
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding window handle of data validation listbox PastorMike[_2_] Excel Programming 2 August 18th 06 07:03 PM
UserForms:listbox display problems Emilie Excel Programming 0 March 23rd 05 04:17 PM
Multicolumn ListBox in Userforms (selecting specific rows) wpllc2004 Excel Programming 1 April 6th 04 08:45 PM
Moving cell values from sheet2 to sheet1 using UserForms and ListBox Stein Kristiansen Excel Programming 0 November 20th 03 07:13 AM
Userforms - listbox question Stuart[_5_] Excel Programming 3 September 2nd 03 12:40 PM


All times are GMT +1. The time now is 01:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"