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.
Presumably the code that opens the form from the button does not populate the combobox.
THANK YOU!
I was thinking it would stay populated if it was populated to begin with, but I guess not.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks