Combobox list box best option

[huorsa]

In column A of sheet1 I have a list of all the customers, in shhet2 I have an invoices template. I want that in sheet2 after typing the first words it appears the complete name.

Per example if I type:
Pe
it appears
Peter White
Peltree Jhon

and I chosee the one I want.

 

[DonkeyOte]

right clikc on the combo box in design mode and look at MatchEntry in Categorized Tab - here you can check by first letter etc...

_________________
LASW10
This message was edited by lasw10 on 2002-11-05 14:31