+ Reply to Thread
Results 1 to 2 of 2

Need help on 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

    Need help on 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 userform 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 to those boxes will overwrite the existing initially entered information in the "succession databse"; but that's not happening. I 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.
    Since this is office work, i'm being able to share limited information only. The template is attached herewith with one hypothetic row of information. I need help on the working of UserForm2.

    PLEASE HELP ME!
    Attached Files Attached Files
    Last edited by raseen20; 03-25-2013 at 02:48 PM. Reason: to ensure a proper title for the thread

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

    Re: Need help on VB coding for using excel userform to edit and overwrite an existing data

    Is there anyone who can please have a look into my query and please help?

+ 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