Dynamic combobox

[pedjvak]

Dear all
I clear my problem as below:
1.I have a data (name) in A1:A10
2.I want to have a combo box from this area
3.I want if we have new name which is not in my list (A1:A10) then when I type in combo box the new one it will be added to my list (it means added to area then my new area will be A1:A11)
4.I want when I type in my combo box it will be suggested to me for example :if I want type "duffry" when i type "D" in combo box it suggested me all of word that will be started by "D"
I appreciated for your comment

[pedjvak]

No body there to help me?!!

[blue.chio]

Hi,

see one of your old thread with a very good solution for you.
http://www.excelforum.com/excel-prog...combo-box.html

[abousetta]

Hello @pedjvak, unfortunately:

This is a duplicate thread and as such does not comply with Rule 5 of our forum rules. This thread will now be closed by one of the moderators, you may continue in your other thread.

Thread Closed.