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

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