+ Reply to Thread
Results 1 to 4 of 4

Check for Duplicates when using a userform

  1. #1
    Registered User
    Join Date
    03-22-2017
    Location
    San Francisco
    MS-Off Ver
    Windows 7 professional
    Posts
    29

    Question Check for Duplicates when using a userform

    I have a userform with textbox 1, textbox 2 and textbox 3 and a submit button.

    The information goes to a worksheet.

    I want to do a check when I submit new data that it checks if there is not any other row with the same values in textbox1 and textbox 2?

    Thanks for helping me out with the code.

  2. #2
    Forum Contributor Toonies's Avatar
    Join Date
    07-30-2009
    Location
    Newcastle, UK
    MS-Off Ver
    Excel 2016
    Posts
    503

    Re: Check for Duplicates when using a userform

    have a look at one of my previous posts it should help you

    https://www.excelforum.com/excel-pro...ml#post3159559

    or you upload an example of your file

  3. #3
    Registered User
    Join Date
    03-22-2017
    Location
    San Francisco
    MS-Off Ver
    Windows 7 professional
    Posts
    29

    Re: Check for Duplicates when using a userform

    So here is my code. So basically what I want to do is that if TextDate, TextWorkOrder, TextSublot and CmdProcess is the same for a certain row then to say that it is a duplicate and that the entry already exists.

    Here is the code.

    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    03-22-2017
    Location
    San Francisco
    MS-Off Ver
    Windows 7 professional
    Posts
    29

    Re: Check for Duplicates when using a userform

    Hi Please I still need help with this thread? I wasn't able to get it from your example.

    Thanks for your help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA UserForm.Value Check If User Form Buttons checked Not Working. Check Button on Open.
    By Doc.AElstein in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 05-11-2016, 05:55 PM
  2. Userform to check 2 textboxes for duplicate & date check
    By LadyAlina in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-24-2015, 09:26 AM
  3. To Check Duplicates
    By pravn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-09-2014, 04:17 PM
  4. [SOLVED] UserForm Auto Check check boxes if TextBoxes are not empies
    By MariaPap in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-12-2013, 11:36 AM
  5. Check for Duplicates when user enters values in the UserForm
    By s2jrchoi in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-27-2012, 03:43 PM
  6. Macro to check for blank cell entry, copy previous value, and check for duplicates
    By xPunxNotDeadx in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-26-2009, 06:33 PM
  7. Macro to check for duplicates and highlight duplicates
    By obc1126 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-23-2008, 09:55 PM

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