PDA

View Full Version : How I can Search on ListBox



aserifkuzu
06-14-2017, 11:19 PM
Hi everybody,

Firstly sorry for my bad english, I hope you can understand me.

Now
1) I've a lot of value on 'sheet2' & 'B' Column.
2) I've a listbox at 'sheet1' which uses the values on 'sheet2'. (I choose a value on that listbox and apply the macro)
3) It's hard to find the value I'm looking for because there are a lot of values on 'sheet2'

?) Can I make a searchbox on top of the listbox which show values when I type some words in this searchbox?
It's hard to find the value I'm looking for because there are a lot of values.It's hard to find the value I'm looking for because there are a lot of values.It's hard to find the value I'm looking for because there are a lot of values.

snb
06-15-2017, 12:11 AM
Use a combobox instead of a listbox.

aserifkuzu
06-15-2017, 01:03 AM
Use a combobox instead of a listbox.
But I can not type any thing on the combobox so its not solve my problem, of course if I didn't make any mistake.

snb
06-15-2017, 01:26 AM
You can type anything you like in a combobox, it derives its name from that property.

aserifkuzu
06-15-2017, 02:16 AM
You can type anything you like in a combobox, it derives its name from that property.

snb I only choose value ı can not type anything for quickly find value which I look up.

19500

Paul_Hossler
06-15-2017, 04:58 AM
Use the ActiveX version of the ListBox, you have to enter the ListRange and Linked cell manuall

19501


One of the properties is how to match entry, in this case by First Letter


19502

aserifkuzu
06-15-2017, 05:27 AM
Bro this is so cool but I have to type completely words or first letter of the word which I look up, so this not work on me.
I want like this.

19504

Normal screen. when I type some words, it must filtered values on listbox. Like pic.

19505