VNouveau venuVickwaInscrit le :29/07/2024Dernière activité :06/09/2024 à 20:45Version d'Excel :2019Messages8Votes0Fichiers0Téléchargements0SujetsMessagesStatistiquesVotes reçus Messages postés par VickwaDateAuteur du sujetSujetExtrait du message28/08/2024 à 16:18VickwaExcel VBA filter searchI understand you. Thank you...28/08/2024 à 13:19VickwaExcel VBA filter searchThank you for the responds.When i select the sheet name and the year then click the filter buttonit gives me error code 1004 and hihlight as attached The second issues is after saving data, when you search by year and month then edit the data and you forget to click the update button and clik the sa...23/08/2024 à 14:52VickwaExcel VBA filter searchPlease kindly assist me with error am getting and I have attached a copy. I want to filter by sheet name and year to the monthly summary. And also want to prevent duplicate year and month when saving data on the user form. Thank you...31/07/2024 à 20:48Vickwa Excel VBA search with two criteria and then upadte on a multiple sheetsThank you so much. That has solved my problems...31/07/2024 à 17:53Vickwa Excel VBA search with two criteria and then upadte on a multiple sheetsThat when you activate the active sheet and populate the fileds and save it. Then you should be able to edit the submitted data by activating the active sheet and search using year and month criteria to populate the other fields. Edit and hit the update button. Thank you...30/07/2024 à 20:10Vickwa Excel VBA search with two criteria and then upadte on a multiple sheetsIt is not working as expected so I want to change it to the combobox. Am asking to clarify if its only the search textbox to be changed to combobox or any other one. Thank you...30/07/2024 à 19:29Vickwa Excel VBA search with two criteria and then upadte on a multiple sheetsThank you. Please if I get you clear, you are suggesting that, the search textbox should be changed to combobox. Kindly help me with the fixes and where to reduce the number of fields. Thank you...29/07/2024 à 19:00Vickwa Excel VBA search with two criteria and then upadte on a multiple sheetsPlease I am having problem with userform to activate a sheet then searching with two criteria that is by year and month to populate other fields and then update.Kindly assist me. Iam new to vba. Thank you Have attached the file...Forums