+ Reply to Thread
Results 1 to 2 of 2

Check Customer Database, if not found, update database.

  1. #1
    Forum Contributor pipoliveira's Avatar
    Join Date
    08-09-2012
    Location
    Ireland
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    368

    Check Customer Database, if not found, update database.

    Dear All,

    I hope you are all well.

    I have a Customer Database table with about 600 customers. That table is on a hidden sheet.

    I have a sheet named "Home" wich I have a cell that you can look up for a customer by typing the Customer Number. on the cell below, I have a VLOOKUP formula that brings the customer name in case the same is on the database.
    Below that cell, I have a CommandButton to add new entries/Customers.

    I need a code, if possible, that if the user type (In the cell I mentioned above) a customer code that is not maintained in the Database or not existing, a Information Box will open informing that the customer does not exist in Database with the option (CommandButtons "Yes" and "No") to add a new entry. If the user type "Yes", the userform I have to add a new entry opens, if the user type "No", delete the code he typed and leaves the Cell blank.

    What I have at the moment is using the "Data Validation", but I can only have a Information Box informing that the number typed is not existing, but no option to click a button and create a new entry.

    Any ideas?

    Your assistance on this matter will be highly appreciated.

    Best regards,
    Filipe Oliveira.

  2. #2
    Forum Contributor pipoliveira's Avatar
    Join Date
    08-09-2012
    Location
    Ireland
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    368

    Re: Check Customer Database, if not found, update database.

    Problem solved.

    The cell I mentioned that have the Vlookup formula is "Z18", so in case the customer number is not maintained in the table, it opens the UserForm I have.

    The code is the following:

    Please Login or Register  to view this content.
    Regards,
    Filipe Oliveira

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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