'Combo box Partial match go to Row
I have a excel file with 2 worksheets, Production and PlantList. The Production worksheet lists plant varieties by size with their corresponding production numbers. Each variety may have multiple sizes. The Production worksheet is created by taking the production varieties list and removing duplicates then finding the first size listed and then finding the corresponding row. I currently search with a combobox using the plantlist (3 columns (name, sizes, row)) to find the row then press a button to go to the listed row.
This method insists that the combo box be typed exactly as the PlantList variety is shown. I would like to be able to enter partial information then choose from the options and then go to the correct row when the option is chosen.
Suggestions?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|