Find Cell Containing String and list in Userform Listbox

[superdonk]

Hi folks

I'm looking for the code i would need in order to search cells C5:C800 and list the value of a cell in a userform listbox that contains certain text based on what was entered in textbox1.

Any ideas?

[millz]

Maybe this:

Please Login or Register  to view this content.

[superdonk]

Thanks, however...

I get a type mismatch error on:

Please Login or Register  to view this content.

Any thoughts?

It seemed to work ok, but then the error kicked in

[millz]

I don't know why 'it seemed to work ok,' and then not.
See if changing to this helps?

Please Login or Register  to view this content.

[superdonk]

That's worked great!!

Thanks for your help!

TVM

[superdonk]

Another one on this - i hope you can help...

What if i want to populate the listbox with the information in column "C" and column "B"

is this possible and what would be the code?

[millz]

Just change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Edit: but keep in mind that's ~1600 loops for every single key entered. You might want to use a command button to "activate" the search.

[superdonk]

unfortunately that didnt work...

I changed the listbox properties to column count of 2 but still nothing?

TVM

[millz]

Hmm did I misunderstand your question? You initially wanted to search in column C, now you want to search both columns B and C is that right?

Or did you just want to search column C, but for that matched record you want to display information from column B and C?

[superdonk]

Oh sorry, didnt explain it very well!

I only want to search in Column "C" but display information from Column "B" & "C" - as what you said last.

TVM

[millz]

Ok, keep the column count at 2, try this:

Please Login or Register  to view this content.

[superdonk]

thats working brilliantly, thanks.

One last thing - is there anyway of swapping the listbox columns around...

currently the information is reading "C" then "B" in the listbox, but i'm after it displaying "B" then "C"

picky I know! sorry

[millz]

Change to:

Please Login or Register  to view this content.