oscyes
Mechanical
- Oct 29, 2013
- 19
hello everybody,
I am here because I am trying to do some userform in order to get some information and paste it to a sheet wich has a template so i can print it with the information i put in the userform.
the thing is that I have some comboboxes where I need to choose an item from a huge list. if I do it by typing in the combobox, it will autocomplete but just with the initial letter, thats not useful enough. i would like to know if is it possible to make a multiple keywords search method in a combobox:
For example if a have the following list:
red car
a car with a red tire
cartoon
then if a type "car" in my combo box, it should show my three items, but if a type "%car%tire%" being "%" the symbol to separete my two keywords, it should show just the item " a car with a red tire"
I hope you can understand what I am trying to explain. it will be very useful for my application to have a search method like that.
thanks in advance
=)
I am here because I am trying to do some userform in order to get some information and paste it to a sheet wich has a template so i can print it with the information i put in the userform.
the thing is that I have some comboboxes where I need to choose an item from a huge list. if I do it by typing in the combobox, it will autocomplete but just with the initial letter, thats not useful enough. i would like to know if is it possible to make a multiple keywords search method in a combobox:
For example if a have the following list:
red car
a car with a red tire
cartoon
then if a type "car" in my combo box, it should show my three items, but if a type "%car%tire%" being "%" the symbol to separete my two keywords, it should show just the item " a car with a red tire"
I hope you can understand what I am trying to explain. it will be very useful for my application to have a search method like that.
thanks in advance
=)