+ Reply to Thread
Results 1 to 1 of 1

VBA Excel "Edit" Button

Hybrid View

lolkit VBA Excel "Edit"... 11-25-2012, 08:51 AM
  1. #1
    Registered User
    Join Date
    11-17-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2007
    Posts
    1

    VBA Excel "Edit" Button

    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
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1