+ Reply to Thread
Results 1 to 3 of 3

Stopping duplicate entries

  1. #1
    Forum Contributor
    Join Date
    04-18-2013
    Location
    utah
    MS-Off Ver
    2010
    Posts
    668

    Stopping duplicate entries

    The attached workbook has combo box that employees choose their name from and then enter their password. If they enter their password correctly then their name goes into the combo box as well as two other areas. If they for some reason enter an incorrect password then the box remains empty. What I need to figure out(and have failed terribly so far) is 2 things. 1) if they enter and incorrect password the combo box stays empty but it still enteres their name in the additional cells. I want to block it from entering their name if a incorrect password is entered. 2) I want to eliminate entering their name in to the same cell range more than once. as you can see over around cell P53 I have it broken up into lines 1-6. I do not want it to populate a duplicat name within the same line number. also starting at line V51 I don't ever want it to populate a name more than once.

    9675A.xlsm

    Password for the VBA project is Touchdown_97

  2. #2
    Registered User
    Join Date
    11-13-2006
    Posts
    87

    Re: Stopping duplicate entries

    The attached workbook has 57 combo boxes, and no names on 'em. (Sorry Bruce)
    well, I for one, am not going to analyze that entire code just to figure out which control (cmb1 to cbmn) you are talking about.

    How about giving a little bit more detailed information

  3. #3
    Forum Contributor
    Join Date
    04-18-2013
    Location
    utah
    MS-Off Ver
    2010
    Posts
    668

    Re: Stopping duplicate entries

    The combo boxes in question are the ones with drop downs next to the start stop buttons, and I believe in the attached file there are already names in four of them. They are labeled cmb1-cmb6. If the worksheet is protected(I thought I unprotected before sending) then the password for that is perfectsq. if you need anything else to help am very happy to get it to you. this has been stumping me for awhile.

+ 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. Replies: 0
    Last Post: 06-14-2012, 12:38 PM
  2. Duplicate Entries into List of Unique Entries
    By MjRmatt in forum Excel General
    Replies: 1
    Last Post: 08-18-2010, 11:53 AM
  3. Duplicate entries
    By Bridget Clyde in forum Excel - New Users/Basics
    Replies: 12
    Last Post: 08-07-2007, 06:00 PM
  4. Duplicate Entries
    By luckyphil in forum Excel General
    Replies: 4
    Last Post: 06-18-2007, 05:52 AM
  5. Stopping Duplicate data entry
    By barry_jordan in forum Excel General
    Replies: 3
    Last Post: 11-30-2006, 04:03 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