How to het the text in a combobox be something not in the list?

[AdLoki]

Hi All,

This should be really simple but I've never been able to figure it out.

I have comboboxes on a form. I want the text displayed in the combobox before the user clicks it to be the title of that list, rather than an item in the list, e.g. I want the text it displays to be "Select your option" but i don't want that to be an entry in the list.

I know you can set the text property in VBE so that it defaults to that value but my problem is that, once I programmatically clear the list I want to reset the text to be "Select your option" - but if I try to set the text or value parameters to something that isn't an item on the list it kicks out an error. If I add "Select your option" to the list, it then means the user might accidentally select that item, which I don't want to happen.

I tried adding a "_DropButtonClick" procedure that deletes the "Select your option" item from the list but if you then don't choose any item, it kicks out an error because the value <> a list item...

Any thoughts?

Thanks

[Norie]

Have you set the combobox's MatchRequired property to True?

If you have that could be the problem.

Try changing that property to False and checking the value of ListIndex.

If ListIndex is -1 then nothing has been selected.

[AdLoki]

Oh God, thank you so much! This has bugged me for years - I knew it was simple!!