Perform search & return complete text out of a range but not the full cell content

[aguilarpro]

I have a form that I have been struggling with and the types of excel built in functions haven't achieved what I want. This is want; I want to include a string query from a textbox and if the text partially matches; it will add it to the listbox as a complete text. I have this:

Please Login or Register  to view this content.

Please share your ideas. Thanks!

[Norie]

Can't you just use this?

Please Login or Register  to view this content.

PS Might not be a good idea using val for a variable name, could get confused with VBA's Val function.

[aguilarpro]

no; my intent is to get just a text that met the partial content (substring), not the entire cell content as you describe.

[Norie]

Do you mean a single word?

If you don't how would you determine what part of the text to take from the cell?

[aguilarpro]

If you look at the array "keyword"; it holds 4 prefixes; the If statement is a value from a textbox that is the designated target. For instance if the entered part matches column A2, then it will move over to V2 and start looking for the prefix value in the array. The reason these are prefixes is because they can be different numbers but will always start with those prefixes; I want to be able to extract the rest of those numbers and populate them in the listbox.

I need help in determining how can the rest of the word can be extracted; could be something like instr(Range("V" & i).value, letterHolder + 1, " ") stating that it will stop when a 'space' is found. I'm just not sure how that can be achieved by getting those letters together to form the word/text.

[Norie]

Any chance you could upload a sample workbook?

Click on GO ADVANCED, scroll down and click Manage Attachments.