Hi All,
I am very new to VBA without programming background and is trying to develop a simple appraisal form.
Problem:
My problem encountering now is Edit and Save button in userform. First, I click edit button and input the new data into the fields for example Appraisal's Comment, then click the Save button but the new data did not update to the correct person in the spreadsheet (Sheet1).
Concept of this form:
As the information are confidential, I used alot vlookup function to pull employee data from Eelist into the userfrom and use Sheet1 to host the new data input by the reporting manager. Those cells in spreadsheets highlighted in yellow are for vlookup function in the Sheet1 and Eelist spreadsheets. Also, in order for user to load the employee data into the uerform, the form is hard coded which the user need to key in the assigned password -DavidY3344 or yi1233 or Sumi0988 to load their respective employees information into the form.
Any oneplease help with this form as per attached? It's the Save Button that is not updating the edited information correctly into Sheet1.
Many thanks in advance![]()
Bookmarks