PDA

View Full Version : VBA Excel - Update Data using UserForm



cjvdg
01-26-2021, 11:18 PM
Hello! I'm trying to make a CRUD function in my worksheet, but I'm having a trouble with the UPDATE part. How can I update a specific data? The unique key is the student ID. In my sample worksheet, I have a result sheet which do have a search and update button. The search function is working but the update function is not. It adds data in the DATA sheet and not update. Upon researching, it says that I need to find the student ID first, then the update function will happen next. Can someone help me with this? I'm just new in this field. Thank you!