Dropdown List....

[Guest]

I'm an Access Programmer.

How can I see "2 columns" of info in Excel like an Access dropdown..IE..

1 Apples
2 Bananas
3 Oranges

....which in Access comes from a SQL.

TIA - Bob

 

[Debra Dalgleish]

If you mean a data validation dropdown, you can use a worksheet formula
to combine the values in two columns, then show the combined values in
the data validation list. There's an example on the following page:

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

Under Data Validation, look for "Data Validation Columns"

 

[Guest]

Debra - Ah Yes...simple String concatenation.
WORKS like a Champ.

Thank you - Bob