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!!
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!!