Error message when inputbox entry does not match UF listbox item

Dear Excel enthusiasts,

I have a search button that selects a matching item (e-mail address) in a userform listbox. The search button opens an inputbox in which to type your entry.
The entry has to meet certain formatting criteria mentioned in the code below.

I would like to have an error message "ENTRY NOT FOUND" if the inputbox entry does not match any of the listed e-mail addresses. However, my code returns this message also/even when the input entry DOES match a listbox item. Anyone knows the reason why this happens and could alter the code accordingly?

Please Login or Register  to view this content.

Hi Torachan,
I uploaded the workbook with desensitised data. I hope it makes the issue more clear. Testsheet with UF code.xlsm

.
Hello.
Try with:

Please Login or Register  to view this content.

Hi Beyond Excel, thanks for your swift answer. I am not really familiar with arrays but your mysterious code seems to do the job.

Do you know how to adapt your code when the first three or more initial letters of the entered mail address should give a matching list item result as well?

Hello.
I find that what I am attaching is quite intuitive to use.

>With each letter you type in the comboBox, a database lookup will be performed.
>The Add and Remove buttons work "just like you imagine."
>When you type a new email address in the comboBox and press any Add button, the address will be added to the corresponding listBox as well as the general list.
>And the upper Remove button removes the address selected in the comboBox from the general list.

Please Login or Register  to view this content.

Hi Beyond Excel. Your combobox solution is very intuitive indeed. I guess that if I want to add duplicate entry or no blank entry restrictions for adding new e-mail addresses in the general list, I include those criteria in the Private Sub Add(lb) coding, right?
Or will "add item"-restrictions also affect the search function with the same restrictions (which is to avoid)?

You can fix the duplicate entry by replacing what I passed you with this variant:

Please Login or Register  to view this content.

Although it may be cheaper to do it like this:

Please Login or Register  to view this content.

Wow, you are a genius man. I only added the criterium of no commas in a new entry but it still adds entries with commas. Any idea why?

Please Login or Register  to view this content.

How about you consider replacing commas with periods automatically?...

Please Login or Register  to view this content.

That works fine.
My last question: How can I force a new entry to avoid any spaces and to end on "@x.y.z"?
And have a message box pop up "there should be at least one sender address" when there are no addresses in the sender listbox?

Hi,
I added the following code to transfer the listbox entries to a named range table "SList" (with the sender e-mail addresses) on a worksheet, but it does not seem to work 100%. Anyone has an idea on how to improve the code?

Please Login or Register  to view this content.