How can I make a drop down list which shows all records

[gibrambo]

Using Excel XP , I used data validation to create a drop down list.
The problem is when i click the arrow the drop down box shows only th
first 8 of the 50 records from the list.
How can i have the full list displayed without scrolling up and down

 

[Debra Dalgleish]

The data validation dropdown is limited to 8 rows, and can't be changed.

If you can use macros, there's a sample file here that provides a
combobox from which you can select one of the values. In a combobox, you
can set the number of rows in the dropdown list:

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

Under 'Data Validation', look for 'Data Validation Combobox'

 

[gibrambo]

Thanks for the quick response.

I have gone through the example, from the link you have given, but whe
i go in the combobox property settings, there is no option to increas
the number of rows.

All I find is:
DisplayPageBreaks
DisplayRightToLeft
EnableAutoFilter
EnableCalculation
EnableOutlining
EnablePivotTable
EnableSelection
Name
ScrollArea
StandardWidth
Visible

Do I need to increase the rows through VB

 

[Debra Dalgleish]

Those are the worksheet properties.
Select the combobox, and you should see its properties.
Then, change the ListRows setting.

 

[gibrambo]

Finally solved my problem with your advice.
Works just as I want it.

Thanks alot Debra.

 

[Debra Dalgleish]

You're welcome. Thanks for letting me know.

Finally solved my problem with your advice.
Works just as I want it.

Thanks alot Debra.