+ Reply to Thread
Results 1 to 3 of 3

Find a duplicate number in cell range and displaying a message box.

  1. #1
    Registered User
    Join Date
    04-08-2014
    Location
    Hendersonville, NC
    MS-Off Ver
    Excel 2010
    Posts
    3

    Cool Find a duplicate number in cell range and displaying a message box.

    Hello,

    I have a list of cells all in the same column(33 of them). Individuals have to rank each cell that corresponds to a task beside the cell. I need to check the range each time the individual enters a value from 1-33 on each cell that there is no duplicates that exist. If there is, then a Message box would appear stating "Number already Used", with just "OK" from the Message box, but not letting individual go to another cell until condition is cleared.
    Any help would be greatly appreciated.

    Chris Jones
    customautomation3@gmail.com

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Find a duplicate number in cell range and displaying a message box.

    You can get something close to this by simply using conditional formatting to highlight duplicates. It doesn't stop them being created but makes it very obvious when they have.
    Martin

  3. #3
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,709

    Re: Find a duplicate number in cell range and displaying a message box.

    Or you could try a "Private Sub Worksheet_Change" macro

    Please Login or Register  to view this content.
    This works for values entered in the B column, right click on the sheet tab click "View Code" and paste the code in the new windows that opens.

    Alf

+ 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] Displaying a message when a cell is edited.
    By brashid in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-30-2013, 12:40 PM
  2. How to find out the duplicate number and show it in a new cell?
    By Junh in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-31-2012, 12:35 AM
  3. displaying in a message box whole rows depending on a cell's value
    By ordeayn in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2012, 06:40 AM
  4. Replies: 11
    Last Post: 04-28-2011, 09:37 PM
  5. to find duplicate cell in a range
    By mingali in forum Excel General
    Replies: 4
    Last Post: 06-03-2010, 03:27 PM
  6. Replies: 2
    Last Post: 08-06-2008, 02:09 PM
  7. checking cell contents and displaying a message
    By brownstone in forum Excel General
    Replies: 4
    Last Post: 05-24-2007, 05:54 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