Drop down list help

[Dave]

Excel 2003I have created a drop down list in a cell(s) and I want the list
to show all values with out a scroll bar. The list is not long (maybe 20
values in the end)

Anyway to do this?

Thanks

Dave

 

[Gord Dibben]

Only with a combobox....................Data Validation dropdowns are
limited to 8 items.

Debra Dalgleish has a sample workbook with a 12 item combobox tied to a DV
dropdown.

Can be easily changed to your 20 items.

http://www.contextures.on.ca/excelfiles.html#DV0020


Gord Dibben MS Excel MVP

 

[Dave]

Thank you.

I am using data validation dropdown.
I will look at her workbook

Dave

 

[Gord Dibben]

Good luck.

If you need help adapting to your own workbook feel free to post back.


Gord