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