+ Reply to Thread
Results 1 to 4 of 4

Userform enter data/update data/delete data

  1. #1
    Registered User
    Join Date
    11-15-2012
    Location
    United States
    MS-Off Ver
    Excel 2016
    Posts
    36

    Userform enter data/update data/delete data

    I have created my first userform, simply it look up a provider name from a list and pre-fill some information then we fill the rest of the form, if the provider is an MG the data is populated in the MG sheet else MP sheet.

    The provider could be entered many times for different records.

    My question is that:
    Using the form or (another form for Lookup and update) I would like to ADD a button so that someone can enter the provider's name and look up the record(s) that are already have been entered in the past in either sheet "MG" or sheet "MP" so that it could be corrected or to enter more fields that was left empty the first time the record was entered, so simply update already existing records using the form. Please note that when someone looks up the provider's name there may have been several records for this provider, so I need to have a mechanism to search through the multiple records for the provider to find the one record that I need to modify and update.

    I am attaching my file.

    Thank you
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    11-15-2012
    Location
    United States
    MS-Off Ver
    Excel 2016
    Posts
    36

    Re: Userform enter data/update data/delete data

    I am not sure if I am an outlier!
    As of today 87 users have viewed my question and NO ONE TO MAKE AN ATTEMPT TO ANSWER! WOW
    THANK YOU ALL ANYWAY.

  3. #3
    Registered User
    Join Date
    07-27-2014
    Location
    Saudi Arebia
    MS-Off Ver
    Microsoft 10
    Posts
    56

    Re: Userform enter data/update data/delete data

    Dear i will help you if i can
    so please wait i just understand your file ok

  4. #4
    Forum Contributor
    Join Date
    09-30-2013
    Location
    Toronto, ON
    MS-Off Ver
    Excel 2007
    Posts
    229

    Re: Userform enter data/update data/delete data

    One thing I found with your sheet is that when a provider is entered, an error is thrown in the following line saying "Can't find project or library" and highlighting MainList
    Please Login or Register  to view this content.
    To understand your requirement better.
    At some point the User will determine that data needs to be corrected and at that point they will hit the new Add button.
    Then you need to search the MG and/or MP tabs to find the Provider name.
    You want to review multiple rows of that Providers data to select the row in error. Can the Provide appear in both the MG and MP sheets, or only in 1?
    If the Provider isn't found in any sheet, what happens?
    How do you want the multiple rows displayed? In an excel tab or via a drop down list or something?
    If this helped, please click (*) Add Reputation

+ 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