+ Reply to Thread
Results 1 to 2 of 2

Excel Tutorial: Warning If A Column Has Duplicate Values With Msgbox

  1. #1
    Registered User
    Join Date
    01-17-2017
    Location
    usa
    MS-Off Ver
    2003
    Posts
    7

    Excel Tutorial: Warning If A Column Has Duplicate Values With Msgbox

    While entering data if there are duplicate values in a column ,can be warning with msgbox.

    The MsgBox in this template shows repeated values that are in which row .If you want, you can enter repeated data or can delete it.

    The used code:
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by JBeaucaire; 02-28-2017 at 01:30 PM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,933

    Re: Excel Tutorial: Warning If A Column Has Duplicate Values With Msgbox

    I will move this to the Tips and Tutorials
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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] MsgBox count of unique values minus column D if equal B or C
    By djfscouse in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-25-2014, 04:49 PM
  2. Create a row (or column) of non-duplicate values from a column containing duplicate values
    By 777volkov777 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-17-2013, 11:11 AM
  3. [SOLVED] If duplicate is found in column B, delete Row, if not, msgbox and exit
    By VBA FTW in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-18-2013, 11:34 AM
  4. [SOLVED] Need Urgent help on Adjacent values of Duplicate column values should be be in single row.
    By anto_01 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-11-2012, 09:55 PM
  5. Warning while entering duplicate values in a cell
    By Raj Mazumdar in forum Excel General
    Replies: 3
    Last Post: 09-17-2012, 03:12 AM
  6. Warning msgbox when closing a userform
    By JamesT1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-13-2008, 01:20 PM

Tags for this Thread

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