copying combo boxes

J

John

Sorry if this is a simple question but I am fairly new.

I made a combo box in excel and it works fine. I then copied that
combo box
to 10 other cells in the same column. What happens if I select any
item from
any one of my 10 combo boxes all the other 9 fill in when same
information.
What do I need to do to allow each combo box to be able to select it
own information.

Another question I have is if the information I want to is not in the
combo list how can a manual enetr the information and have it added to
the combo list.

Any help or suggestions would be greatly apreciated
 
D

Dave Peterson

It sounds like the linked cell for all of your combobox still points to the same
cell.

Time to update the linked cell for each????
 
Top