MixedUpExcel
Board Regular
- Joined
- Apr 7, 2015
- Messages
- 222
- Office Version
- 365
- Platform
- Windows
Hi,
I've not found what I am looking for, so if someone can point me in the right direction if this has been done before please?
I have a Combo Box on Sheet1
I have a list of items (approx 200) on Sheet2 in Column A (which will be my range and is set as a dynamic named range) - also, it doesn't start in A1 (data above the range which I don't want to use and also data below the range that I don't want to use)
As a working Combo Box list - the above works fine, however, I've been asked to make it simpler to find products in the drop down list.
I would like the user to be able to type into the Combo Box field and it will show any results which contain what they are searching (regardless of whether they put the first letter, middle letters or end letters into the search field in the Combo Box).
I would also like the Combo box to start with 10 rows but if the user, say, gets down to 3 options, it only shows 3 rows (not too important if it can't be done)
Can this be done with VBA and where should I look to find out how?
Thanks in advance.
Simon
I've not found what I am looking for, so if someone can point me in the right direction if this has been done before please?
I have a Combo Box on Sheet1
I have a list of items (approx 200) on Sheet2 in Column A (which will be my range and is set as a dynamic named range) - also, it doesn't start in A1 (data above the range which I don't want to use and also data below the range that I don't want to use)
As a working Combo Box list - the above works fine, however, I've been asked to make it simpler to find products in the drop down list.
I would like the user to be able to type into the Combo Box field and it will show any results which contain what they are searching (regardless of whether they put the first letter, middle letters or end letters into the search field in the Combo Box).
I would also like the Combo box to start with 10 rows but if the user, say, gets down to 3 options, it only shows 3 rows (not too important if it can't be done)
Can this be done with VBA and where should I look to find out how?
Thanks in advance.
Simon