+ Reply to Thread
Results 1 to 1 of 1

VB coding for using excel userform to edit and overwrite an existing database

  1. #1
    Registered User
    Join Date
    03-25-2013
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    Excel 2007
    Posts
    3

    VB coding for using excel userform to edit and overwrite an existing database

    Dear All,

    I've tried to make 2 userforms for a succession plan office project.

    Userform1 (Data Entry)
    1st part of the form extracts data from the "master database" sheet.
    2nd part of the form is used to enter data into the "succession database" sheet.
    This userform1 works perfect.

    Userform2 (Data Edit)
    This form is used to first extract and show the data entered into the "succession databse" sheet. The information is shown in textboxes and I expect the changes made in those textboxes will overwrite the existing initially entered information in the "succession databse"; but that's not happening.
    I also wanted to have a combobox with just the employee's name to filter/dropdown and auto-retrieve the rest of the information but couldn't make anything happen so opted for the listbox.
    The template is attached herewith with one hypothetical row of information. I need help on the working of UserForm2.

    PLEASE HELP ME!
    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