Get selection from ListBox and copy to TextBox (USERFORM)

Happy New Year
And Thank you for taking a look at my problem.

What i have:
A Userform where I type a zip code in the textBox and while typing the ListBox shows the matching possibilities from a Range.
The Range is merged cells from a Table where I have Zip code in Col 1 and City in Col 2.
I can only search by ZipCode.

Example workBook Uploaded.



What I relly would like:
- A Userform where I would like a way to type in the textBox while the ListBox shows the values from a Table with Zip code in Col 1 and City in Col 2.
- While typing in TextBox the ListBox should only show matching possibilities.
- I would like the option of searching by either Zip Code or City.
- The ListBox should show Zip Code and Matching City (As in merged Cells on Sheet)
- A way to Select the value from the ListBox to the TextBox.

Any Help is much appreciated


A Snip of my code so far:

Please Login or Register  to view this content.

Udklip.PNG

Originally Posted by nordicdust

What I relly would like:
- A Userform where I would like a way to type in the textBox while the ListBox shows the values from a Table with Zip code in Col 1 and City in Col 2.
- While typing in TextBox the ListBox should only show matching possibilities.
- I would like the option of searching by either Zip Code or City.
- The ListBox should show Zip Code and Matching City (As in merged Cells on Sheet)
- A way to Select the value from the ListBox to the TextBox.

Try this:
Notes:
1. searching in textbox is case insensitive, try typing '72 a'.
2. to transfer value from listbox to textbox use doubleclick.

Please Login or Register  to view this content.

Ok, see if this suits your needs.
Steps:
1. The user types something in the text box
2. press tab > focus will go to the listbox
3. use the up\down arrow > press Enter > textbox value = listbox value
4. press tab > focus will go to the GO button

Add these lines to the existing code:

Please Login or Register  to view this content.

Thank you Akuini

This is perfect, I will mark this as Solved.

Originally Posted by nordicdust

Thank you Akuini

This is perfect, I will mark this as Solved.

You're welcome, glad to help.
I modify the code a bit to limit the keypress (in the listbox) to Enter key.

Please Login or Register  to view this content.

Just a thought:
I don't know what the OK button does, but to reduce the steps you need to take, you can just move the code (for your OK button) to the 'Private Sub Listbox_RESULTAT_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)'. That way you won't need the OK button anymore.
For example:
In the modified code above I add :

Please Login or Register  to view this content.

comment out the line to see what happen. I mean you can put in there the code to do what your OK button do .