Drop down list with labels

[DianePDavies]

I know how to create a drop down list for selecting values for a field - but
how do I show a label next to my value?

I want to know which value I am selecting - and instead of just the number
- I would like a label explaining the value. Like in Access you can make the
values - but show e.g. other fields next to them:

6,891 Adam
7,439 Eve
8,125 John

When selecting the value - I want to know to whom it relates.

 

[DianePDavies]

OK.

Now I have trouble assigning the data to the combobox. In which property do
I specify the range of cells with my list data?

 

[Debra Dalgleish]

You can do this with data validation and a bit of programming. There's a
sample file here:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'DV0005 - Data Validation "Columns"'