Predictive drop down menu needed

[saraapple]

After watching various uTube videos I have created a drop down menu which works brilliantly....but it could be better:

Time Change Sheet Master New Improved.xlsm
	A	B	C	D	E	F	G	H
1								1
2		Newport	0	930	Aberdeen	930	Newport	Newport
3			0	125	Altrincham	125
4			0	265	Ashford	265
5			0	345	Ashton Under Lyne	345
6			0	155	Aylesbury	155
7			0	750	Ballymena	750
Stores

Cell Formulas
Range	Formula
G2	G2	=OFFSET($H$2,,,COUNTIF($H$2:$H$180,"?*"))
C2:C7	C2	=IF(ISNUMBER(SEARCH('Front sheet'!$D$7,Stores!E2)),MAX($C$1:C1)+1,0)
H1	H1	=COUNTIF(H2:H180,"?*")
H2:H7	H2	=IFERROR(VLOOKUP(ROWS($H$2:H2),C:E,3,FALSE),"")

Named Ranges
Name	Refers To	Cells
validation_list	=OFFSET(Stores!$H$2,,,COUNTIF(Stores!$H$2:$H$180,"?*"))	G2, H3:H7

Cells with Data Validation
Cell	Allow	Criteria
B2	List	=$H$2:$H$179

This all feeds my front sheet and the drop down menu in D7

Date of Issue:	24/09/2021	DTS Time Change + Volume Report
Date of Delivery:	23/09/2021
				STORE:
			Newport
460				460
			DHL Delivery Times
		Permanent Time			Revised Window
		8.00	-	10.00	0.00	-	0.00
Expected Delivery Volume
Pallets	Over Sized Pallets	Over Height Pallets	Cartons	Over Sized Cartons	Bags	Rolls	Totes	Giraffes	Over Sized Bags
12	0	0	30	12	2	0	15	1	0
		Total Volume
72

The issue I have is making it more user friendly! Currently you type the store name or part of the store name and then click the drop down arrow to see the suggestions - Can I get rid of the arrow and just have the options appear below to select from? So achieving the same result - just more obvious and idiot proof?!?

Thank you for taking the time any ideas always greatly appreciated.
Sara

 

[johnnyL]

Is that an ActiveX Text Box?

Where is the location of the list of store names that is searches through for a match? Is it Sheet names "Stores" E2 - ???

 

[saraapple]

Hi, Thank you for taking the time.
Yes you are correct on the location of the store names.
To my knowledge its not an ActiveX Test box, I created it through the data validation option?

 

[johnnyL]

I don't see how you will be able to accomplish your goal with that approach.