Results 1 to 7 of 7

Prevent Duplicate Entries when Editing Data using Userform

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-14-2017
    Location
    South Africa
    MS-Off Ver
    Office 2010
    Posts
    148

    Prevent Duplicate Entries when Editing Data using Userform

    Good Day

    I have using this user form to add, edit, delete data. The userform thus far works brilliantly thanks to this forum and its members who assisted me.

    I have this issue whereby when I am editing data, I want the system to check that the edited data is duplicated or not. The fields I am particularly concerned about are: ALB Tag# and the Power on Password and Computer Name

    I have attached my spreadsheet for better clarity

    Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Prevent Duplicate entries in multiple column from VBA Userform
    By excel_126 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-18-2014, 03:13 AM
  2. Prevent duplicate entries in Data Validation List By code
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-26-2014, 04:56 PM
  3. Prevent duplicate entries in Data Validation List By code
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-26-2014, 04:37 PM
  4. Replies: 0
    Last Post: 06-14-2012, 12:38 PM
  5. Prevent Duplicate Entries
    By whousedmy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-17-2010, 11:40 AM
  6. To prevent duplicate entries using Data validation.
    By legendkiller420 in forum Excel General
    Replies: 3
    Last Post: 07-09-2010, 07:47 AM
  7. Prevent Duplicate Entries
    By luckyphil in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-07-2007, 08:20 AM

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