Dynamic combo box

**pedjvak** · 07-07-2013, 12:11 AM

Dear all
I need a combo box with this specification :
1. ِDespite I choose the drop down list , when I type in combo box it suggestion to me the name which in my list
2. if I type the name which not in my list it accept and added to my list
3. if it will be possible I don't want use from validation data for combo box
thanks for your attention to my problem

**zumbalj** · 07-08-2013, 08:07 AM

Why not data validation? It sounds like a perfect solution to your problem, unless I am missing something.

**duffry** · 07-08-2013, 08:20 AM

I guess the problem with data validation is requirement 2. If I understand it correctly pedjvak wants to not be restricted to the initial list but to be able to use the cell to add to the option list if something new is typed in that cell.

Don't know of a way to achieve this without VBA.

**duffry** · 07-09-2013, 11:26 AM

Does this help?

http://www.excelforum.com/excel-gene...down-list.html

**pedjvak** · 07-10-2013, 03:32 AM

Dear Duffry
thanks for your attention to my post
I attached the file
could you plz show me how I can added new name in my list by typing in combo box it means when I type in combo box "Johneee" instead of "John"
which is not belong to my source(A1:A10) it will be added to my source list as a new name (A1:A11)

**pedjvak** · 07-10-2013, 03:42 AM

Dear Zumbalj
could you plz show me how you can fix it (my Terms as I issue in my last post) by validation Data ?

**duffry** · 07-10-2013, 04:52 AM

I can't, no. As I said before, I think this would need a VBA coded solution. I may be able to write it but I'm no expert there and it would a) take me quite a while and b) probably not be all that good/robust.

The link I posted seems to get you most of the way there without the name adding feature. Is there any way you can separate this process? If not then I think you need some VBA code.