Dynamic combo box

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

Hi,

it seems to be the same question, please continue over there
http://www.excelforum.com/excel-form...combo-box.html

thanks for your file
could you plz help me in item 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" "
your combo box dosen't have any suggestion
and
could you plz show me how I can connect value in combo box with some cells ?
for example if in combo box we have name1 then in B2 we have the value like a formula or else

THANKS FOR YOUR FILE
ITS WORK IN SOME ITEM NOT AT ALL
COULD U PLZ HELP ME IN NUMBER 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"
AND COULD U PLZ TELL ME HOW I CAN CONNECT THE COMBO BOX VALUE WITH SOME CELLS?
FOR EXAMPLE IF IN COMBO BOX WE HAVE "NAME1" THEN VALUE OF CELL B2 WILL BE C2*E2
AND FINALLY MAY I HAVE A VALIDATION DATA INSTEAD OF COMBO BOX OR NOT? HOW?

Yes you right it is work it hase suggestion thanks

sorry your link was damaged
did you test it ?

could you please tell me may I have cell with validation data instead of combo box?