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