Selecting any cell in a column I want my ComboBox to show. How?

A

ABP MLundqvist

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

pinmaster

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
 
G

Gizmo63

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
 
G

Gizmo63

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

Chris Marlow

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.
 
Top