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?

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?

Use 'Data - Validation' to create a 'list' dropdown in the first cell in your
column (you'll need to build your supplier list somewhere on the same page
first) and then simply copy - paste your first cell down the rest of your
"Supplier" column.
The parameters will go with each paste.

hth
Giz

"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?

Ignore the bit about being on the same page. Defining a named range gets
around that issue.

"Gizmo63" wrote:

Use 'Data - Validation' to create a 'list' dropdown in the first cell in your
column (you'll need to build your supplier list somewhere on the same page
first) and then simply copy - paste your first cell down the rest of your
"Supplier" column.
The parameters will go with each paste.

hth
Giz

"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?

Hi,

Search for 'data validation' in Excel Help.

Briefly;

If the values you want in your drop down are in a column on a sheet you can
set up validation for selected cells using 'Data', 'Validation' then change
the 'Allow' drop down to 'List' & change the 'Source' to your range.

Regards,

Chris.

--
Chris Marlow
MCSD.NET, Microsoft Office XP Master


"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?