Is it possible to edit combo box list?

[banerg]

Friends,

I have combo box in worksheet (using control toolbox) that refers to a list. Is it possible to have user add on to the existing list? Thanks.

 

[Tazguy37]

With VBA it's possible.

You could permanently add an item to the list called, say, "Add new item." When any selection gets made (through a command button, _Change() event, whatever) you could check to see if the combobox.value = "Add new item." If it does, pop up an inputbox asking for a new item, and put it at the end of the current list.

That give you some ideas?

 

[banerg]

Thanks Tazguy. I will give it a shot.