Making a listbox behave like a combobox (drop-down part) but keeping multiselect...

Hey,

Is is possible to have a listbox behave like how a combobox does with the drop down list on a userform? You can't use multiselect with a combobox and I'm trying to avoid using a listbox with scrollarrows, but rather the efficient drop-down list. I'm stuck at the moment...any help would be greatly appreciated.

-Tom

wow, that is surprising and rather frustrating to say the least. Maybe I can change the height of the listbox based on events on the userform because the number of list items is large.

I also noticed that the the "MatchEntryComplete" on the MatchEntry property doesn't function the same on the listbox as it does on the Combobox. I.e.- if you type in more than one letter on the listbox, it doesn't concatenate your entries to converge on an item in your list, but rather only matches the first character on the list items (hope that makes sense). Am I missing something???

Can't you just have a button which makes the listbox visible and hides again when it's clicked?

I'm sure you can which is what I think I'm going to start working with. In my case I have 6 different search criteria option buttons that need to be selected and once selected, the listbox list gets updated. So I'm going to play around with different events and see if I can't get this to work the way I want.

No comments about the MatchEntry property different between Listboxes and ComboBoxes?

It only matches the first 3 letters for me.

This is easy to remedy with a text box, but not if you also need multiselect

I need multiselect. So it matches first 3 letters for you? Only 1 for me....weird.