View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Icy Icy is offline
external usenet poster
 
Posts: 10
Default Filiter and Limit selection in Combo box / List Box in the UserFor

I am having a problem to limit the selection display in the Combo box / List
Box. I would like the Combo Box to display a list of result in the drop down
list as user enter value. I have a data base with 2000 entry, it will be
very helpful to limit the record display in the dropdown list.

Example if user type A in the Combo box the drop list will show
Apple
Age
Adam
Ace
Appointment

if user type Ap then only Apple & Appointment with show on the drop down
list.

Kind of like filter, but the result on the drop down list will change as the
input value changes. Could some one please help. Thank you so much.