• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search function not displaying results


New Member
Hi all.

I am a beginner in VBA, so please excuse me if the code is incorrect. I have put it together using online examples. I am still learning VBA.

I have created a UserForm which adds food items to my excel file. There is also a Search box, which should display any item or items when i type a keyword. However this does not work. When i type a keyword, all related items should display in the listbox through autocomplete or when pressing the search button.

I have not been able to find a template for my exact requirements.

I have attached the excel - Search.xlsm

Can someone help with this please?

Thank you.