Filiter and Limit selection in Combo box / List Box in the UserFor

I

Icy

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top