Results 1 to 5 of 5

Check for duplicate entry in a userform and fill in text boxes with duplicate information

Threaded View

SueW Check for duplicate entry in... 08-20-2015, 04:32 PM
xladept Re: Check for duplicate entry... 08-20-2015, 06:12 PM
bakerman2 Re: Check for duplicate entry... 08-21-2015, 01:12 AM
SueW Re: Check for duplicate entry... 08-21-2015, 11:25 AM
bakerman2 Re: Check for duplicate entry... 08-21-2015, 03:59 PM
  1. #1
    Registered User
    Join Date
    01-31-2014
    Location
    Tulsa, OK
    MS-Off Ver
    Excel 2007
    Posts
    2

    Check for duplicate entry in a userform and fill in text boxes with duplicate information

    Hi all,
    I have created a userform in Excel 2010 for use as an inventory count entry form. After entering a tag number in txt1, txt2 - txt4 is automatically populatd. txt5 - txt6 are manual entries.
    My problem is that a tag number should be entered only once. If the user enters the same number, I need to caution them that the number has already been entered and the entry needs to populate all text boxes with the information previously entered. If the quantity in txt5 then needs to be revised, the user is able to do so.
    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. 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
  2. Replies: 0
    Last Post: 02-04-2014, 12:36 AM
  3. Vlookup with duplicate check and auto fill on duplicates
    By vjmcdonnell in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-13-2013, 11:14 AM
  4. [SOLVED] Prevent duplicate entry in userform
    By vijaynadiad in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-01-2013, 02:29 PM
  5. userform duplicate entry check writing to sheet
    By cfinch100 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-06-2013, 06:21 AM
  6. Code to check for duplicate entry
    By renden in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-02-2012, 05:00 AM
  7. how to check the duplicate data entry in form?
    By jay11 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-18-2010, 01:59 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