Filtering a Listbox with a textbox in a userform

Hey all. I have been trying for days, read other posts, and can't get this to work.

I have a user form. On this form there is a listbox named Values. This box has it's data RowSource set to 'Costsrt'!B5:B1171.
I have a TextBox above it labeled Search_Box.

What I want, is being that I have 1166 entries, to be able to type into the search box, and as I type, it will only keep the lines that include
what I am typing. So if I type safety for example, then the only lines it should show are lines that contain the word safety in it.

Can anyone help me with this? I tried and can't get it to work.

Also, I see a lot of posts saying to use the command line Me.RefreshList

If I put this in, I always get an error. Is this an old line? After Me. I don't even have that as a valid choice.

Thanks in advance!!


Cross post Here: http://www.mrexcel.com/forum/excel-q...-userform.html

Don't use RowSource, it's a horrible property, this is case sensitive, you you need case insensitive it's a little more complex:

Please Login or Register  to view this content.

Thanks for the response! Ill let you know how it works!

It works, but it is case sensitive. How can I make it non case sensitive?

Thanks again!!

Got it. I copied the column to v as all lowercase
And added lcase to the searchbox item. Works
Perfect. When I double click the item it uses the B
Column for the auto fill.
Thanks for the help!!