+ Reply to Thread
Results 1 to 9 of 9

Pop up message box if duplicate exist

  1. 12-23-2013, 08:29 AM #1
    HerryMarkowitz
    HerryMarkowitz is offline
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,007

    Pop up message box if duplicate exist

    Hi,
    How can I pop up message box if duplicate exist in A column ?
    I found following code but it is not working.
    Please correct following code.
    Thanks in advance.
    Please Login or Register  to view this content.
    Sub DontForgetThese()
     If Your thread includes any code Then Please use code tags...
     If Your thread has been solved Then Please mark as solved...
     If Anybody has helped to you Then Please add reputation...
End Sub
    Reply With QuoteRegister To Reply
  2. 12-23-2013, 08:36 AM #2
    Leon V (AW)
    Leon V (AW) is offline
    Forum Contributor
    Join Date
    06-22-2011
    Location
    somerset
    MS-Off Ver
    365
    Posts
    328

    Re: Pop up message box if duplicate exist 

    Please Login or Register  to view this content.
    Sub Reputation()
Dim Problem as Variant
Dim Reputation as Integer
For Each Problem in Forum.Threads
    If Problem.Title = "*[Solved]*" and Solver.Name = "Leon V (AW)" Then Reputation = Reputation + 1
Next Problem
End Sub
    Reply With QuoteRegister To Reply
  3. 12-23-2013, 08:44 AM #3
    jindon
    jindon is offline
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,560

    Re: Pop up message box if duplicate exist

    Try this
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 12-23-2013, 08:45 AM #4
    HerryMarkowitz
    HerryMarkowitz is offline
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,007

    Re: Pop up message box if duplicate exist

    Hi Leon V (AW),
    I dont understand your answer.
    Is it possible adding an excel file ?
    Thank you.
    Reply With QuoteRegister To Reply
  5. 12-23-2013, 08:52 AM #5
    HerryMarkowitz
    HerryMarkowitz is offline
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,007

    Re: Pop up message box if duplicate exist

    Hi jindon,
    I dont understand your answer.
    Is it possible adding an excel file ?
    Thank you.

    Note: I dont want Private Sub Worksheet_Change(ByVal Target As Range) issue.
    I want regular procedure...
    Reply With QuoteRegister To Reply
  6. 12-23-2013, 09:59 AM #6
    HerryMarkowitz
    HerryMarkowitz is offline
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,007

    Re: Pop up message box if duplicate exist

    I found following link regarding this issue.
    Solution in following link is using conditional highlighting to show duplicates.
    But I want to show duplicates in msgbox !
    Any idea ?
    http://www.excelforum.com/excel-prog...-column-a.html
    Reply With QuoteRegister To Reply
  7. 12-23-2013, 10:16 AM #7
    Leon V (AW)
    Leon V (AW) is offline
    Forum Contributor
    Join Date
    06-22-2011
    Location
    somerset
    MS-Off Ver
    365
    Posts
    328

    Re: Pop up message box if duplicate exist 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 12-23-2013, 10:44 AM #8
    mikerickson
    mikerickson is offline
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Pop up message box if duplicate exist

    You could put Excel's vValidation on all the cells of column A with the formula
    =(COUNTIF(A:A, A1)=1)
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.
    Reply With QuoteRegister To Reply
  9. 12-23-2013, 10:59 AM #9
    HerryMarkowitz
    HerryMarkowitz is offline
    Forum Contributor HerryMarkowitz's Avatar
    Join Date
    09-10-2012
    Location
    Europe
    MS-Off Ver
    Office 2021 - Win10
    Posts
    1,007

    Re: Pop up message box if duplicate exist

    Solved...
    http://www.mrexcel.com/forum/excel-q...cations-5.html
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to reference to worksheets that don't yet exist, but avoiding the #REF! error message
    By Haylo in forum Excel General
    Replies: 7
    Last Post: 07-12-2012, 10:30 AM
  2. Validation error message when data does not yet exist.
    By rodge in forum Excel General
    Replies: 6
    Last Post: 04-09-2012, 02:26 PM
  3. The reference is not valid error message for data - but the same ones appear to exist
    By lightecho in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-29-2012, 01:19 PM
  4. Data may exist in the sheet(s) message
    By cedtech23 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-21-2006, 10:15 AM
  5. [SOLVED] Checking that file exist and if not display a message
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-16-2006, 10: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1