Hello,
I want to use autocompletion in a combo-box. I think it's not that hard to accomplish. I already have that code (VBA).
Now I want to do the following:
I have a sheet (ProductSelection) were I have 3 combo-boxes and a lot of other cells which have to be auto-populated when searching for a value typed in one of the three combo-boxes..
The 3 combo-boxes are: Productname, Sort of product & Productnumber. If I click on the combobox 'Sort of Product' and I select a value, the other combo-boxes need to be filled in with the value looked-up from a table (vlookup or index/match).
There are more cells which have to be filled, but I think it will be a combination of 'If-statements' and vlookup or index/match formula's.
Somebody who could help me with this?
Help is much appreciated!
I want to use autocompletion in a combo-box. I think it's not that hard to accomplish. I already have that code (VBA).
Now I want to do the following:
I have a sheet (ProductSelection) were I have 3 combo-boxes and a lot of other cells which have to be auto-populated when searching for a value typed in one of the three combo-boxes..
The 3 combo-boxes are: Productname, Sort of product & Productnumber. If I click on the combobox 'Sort of Product' and I select a value, the other combo-boxes need to be filled in with the value looked-up from a table (vlookup or index/match).
There are more cells which have to be filled, but I think it will be a combination of 'If-statements' and vlookup or index/match formula's.
Somebody who could help me with this?
Help is much appreciated!
