Instead of a combo box, try using a validation list. Start by selecting your
"supplier" cells next go to Data/Validation, select "list" from the "Allow"
menu and in the "Source" box type your list seperated by comas or you can
type your list in a range somewhere, name your range and then use that name
in the "Source" box.... say your list is named "mylist" then use =mylist

HTH

Jean-Guy

"ABP MLundqvist" wrote:

My column called "Supplier" sholud (if possible) have a ComboBox in each cell
so that when I click the ComboBox in any cell, I can select supplier from the
list.
How can I do that?