There are instructions in the workbook for viewing the combobox and
changing its properties. To show more rows, change the ListRows
property, which is currently set at 12.

Pong wrote:
Hi,

Thanks for the quick reply. The sample is almost fit to my needs. But I
have about 500 customer data base and I could not expand the drop down box
more than 7 and 12 rows. Please help.

Pong

"Dave Peterson" wrote:


Copying from google and pasting sometimes adds extraneous dashes.

http://www.contextures.com/excÂ*elfiles.html
should be:
http://www.contextures.com/excelfiles.html



Max wrote:

This previous post by Debra Dalgleish would be of interest:

"Although data validation doesn't support autocomplete, there's a sample
file here that provides a combobox from which you can select one of the
values from the data validation list. In the combobox, you can enable
autocomplete:

http://www.contextures.com/excÂ*elfiles.html

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

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Pong" wrote in message
...

Hi,

I want to create a drop down menu for my customer list. The drop down

menu

should have a auto search function. eg. If I type in "Mic", the drop

down

menu will bring me to the customer name close to "Mic". How can I do it?
Can I update the customer list regularly.

Pong

--

Dave Peterson




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html