+ Reply to Thread
Results 1 to 3 of 3

Thread: combobox list disappears on form close or open

  1. #1
    Forum Contributor
    Join Date
    06-16-2010
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2007
    Posts
    184

    combobox list disappears on form close or open

    Hi - I have a combobox on a userform, the data for the combobox is loaded on workbook open (sql query loads data to a sheet, then loads combo box). This works, when Form opens, data is in combobox and we can choose it and move on.
    HOWEVER, if you close the form before you select any data and then reopen form (from button on sheet), the combobox is empty (list is still there) and I have no code anywhere that changes box to empty.
    There is a change event on combobox, but it doesn't clear it's own contents, you can change your selection and move on.
    Why is combobox empty when you reopen form if you didn't select anything? If you select something, on reopen the list is there.
    Thanks!
    Last edited by ker9; 09-30-2010 at 11:48 AM.

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    Apparently I can't say
    MS-Off Ver
    Apparently I can't say
    Posts
    8,274

    Re: combobox list disappears on form close or open

    Presumably the code that opens the form from the button does not populate the combobox.

  3. #3
    Forum Contributor
    Join Date
    06-16-2010
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2007
    Posts
    184

    Re: combobox list disappears on form close or open

    THANK YOU!
    I was thinking it would stay populated if it was populated to begin with, but I guess not.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.2.0