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?