dos
06-25-2019, 01:32 AM
Hi all.
I am currently learning Excel VBA, so class myself as a beginner.
I managed to create a UserForm that can add food products and i also added a Search section that should display any product(s) when i enter any keyword of the Item Name. For example, i have a record for Red Leicester Cheese 100g. If i search for only the word "Red" or only the word "Cheese" then all records that have the word Red or Cheese should appear in the Search results box. I also saw on YouTube that as i type the keyword, then real-time search results are displayed. I would like to incorporate this into my UserForm.
I have tried many times to get my UserForm to work, but i am struggling, as there are several problems with it, which i have listed below. Please can anyone help?
1. I added code to the Create Worksheet button and it froze my computer, so i removed the code, but just left the button. Is there code that can get this button to add a new worksheet and also list it in the select sheet combo box?
2. I cannot get the Combo box (Priority) to list its value.
3. The date does not automatically populate.
4. Data is not aligned to its respective column in any of the three worksheets - Dairy, Bread, Drinks. I suspect this is because of the Priority combo box problem.
5. Finally, as explained in the beginning, is there code for the Search section, which can list data in the large search box exactly like it is in the excel file, just by searching on any keyword?
Of course if you have any suggestions to improve the look/feel of the UserForm, please do let me know.
I have attached my excel sample file.
Any help would be greatly appreciated.
Thank you in advance.
Dos
I am currently learning Excel VBA, so class myself as a beginner.
I managed to create a UserForm that can add food products and i also added a Search section that should display any product(s) when i enter any keyword of the Item Name. For example, i have a record for Red Leicester Cheese 100g. If i search for only the word "Red" or only the word "Cheese" then all records that have the word Red or Cheese should appear in the Search results box. I also saw on YouTube that as i type the keyword, then real-time search results are displayed. I would like to incorporate this into my UserForm.
I have tried many times to get my UserForm to work, but i am struggling, as there are several problems with it, which i have listed below. Please can anyone help?
1. I added code to the Create Worksheet button and it froze my computer, so i removed the code, but just left the button. Is there code that can get this button to add a new worksheet and also list it in the select sheet combo box?
2. I cannot get the Combo box (Priority) to list its value.
3. The date does not automatically populate.
4. Data is not aligned to its respective column in any of the three worksheets - Dairy, Bread, Drinks. I suspect this is because of the Priority combo box problem.
5. Finally, as explained in the beginning, is there code for the Search section, which can list data in the large search box exactly like it is in the excel file, just by searching on any keyword?
Of course if you have any suggestions to improve the look/feel of the UserForm, please do let me know.
I have attached my excel sample file.
Any help would be greatly appreciated.
Thank you in advance.
Dos