Drop down list with labels
 

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.

--
Diane

Drop down list with labels
 

To do that, you will have to use a combo box from your control toolbar.
Bound column = 1,
column count = 2

--
HTH

Kassie

Replace xxx with hotmail


"DianePDavies" wrote:

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.

--
Diane

Drop down list with labels
 

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?

--
Diane


"Kassie" wrote:

To do that, you will have to use a combo box from your control toolbar.
Bound column = 1,
column count = 2

--
HTH

Kassie

Replace xxx with hotmail


"DianePDavies" wrote:

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.

--
Diane

Drop down list with labels
 

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

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

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

DianePDavies wrote:
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.



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com