Drop menu autocomplete

[dado6612]

Hi to all

I've created a table to calculate distance between 2 regions.
There are 4 lists created with data validation, 2 of them use country names, defined with "trav" name, other 2 are regions which will show for corresponding country with indirect function. After selection, vlookup formula will check in which zones are selected regions. Finally, index/match will look how far are zones from eachother.
Hope you understand that, what I wish for now is to all 4 lists be autocomplete ones.
When user start to type first few letters of a country, first match would appear as result (CRO=Croatia)*. Same would work for region selection. User would type first few letters and region would come up**.

*If its possible to filter choices as user type.
Ex. "C" will bring Chile, China, Croatia
"Ch" Chile;China
"Chin" autocomplete China
**All mine previous formulas have to work after this new changes

Hope you understand
Thanks

 

[VoG]

You can use a combobox like this http://www.contextures.com/xlDataVal14.html

 

[dado6612]

Thanks, I'll try this

 

[dado6612]

Can't, don't see properties for combobox

 

[VoG]

You need to add an ActiveX combobox (under ActiveX controls when you click Insert on the Developer tab).

 

[dado6612]

Yeah, got it, my codes were password protected. Gonna resume other parts

 

[dado6612]

Doesn't work cause I already have worksheet change in code for same sheet
Ambiguous name for Private Sub Worksheet_SelectionChange(ByVal Target As Range) and for Private Sub TempCombo_KeyDown(ByVal _
KeyCode As MSForms.ReturnInteger, _
ByVal Shift As Integer)

 

[VoG]

Try the double-click version http://www.contextures.com/xlDataVal10.html

 

[dado6612]

same, cause of this part of code

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim str As String
Dim cboTemp As OLEObject
Dim ws As Worksheet
......

</pre>

 

[VoG]

You can only have one Worksheet_SelectionChange event but you may be able to combine what you already have with what is in the link.