Could some one help me, I want to dynamically change the selection in the
drop down list on a userform. So if I have entire such as
Apple
Ace
Appointment
Bee
Bread
Beach
normally, on the combo box it will show all the selection to the user to
pick, I want user type "A "all the selection starting with B will be taken
off
from the selection list, only selection listed below will show.
Apple
Ace
Appointment

When user type "B" all the selection starting with A
will be taken off.
Bee
Bread
Beach
so user can scroll up and down the list and choose what
they need in that range. I don't know whether this is possible for combo box
to do, or do you know if there any other way to accomplish this. Thanks!