+ Reply to Thread
Results 1 to 3 of 3

Vba to display message when duplicate enteries are in the same row

  1. #1
    Registered User
    Join Date
    08-29-2012
    Location
    Scotland
    MS-Off Ver
    Excel 2010
    Posts
    84

    Vba to display message when duplicate enteries are in the same row

    I am looking to display a message when values are the same within a certain range on my worksheet. For example from A5:S5 if the same value is entered in that row twice I want a message to display warning the user.
    I know how to display a message box in vba but cant work out the first part.
    Any help.
    Thanks.

  2. #2
    Forum Expert
    Join Date
    06-09-2010
    Location
    Australia
    MS-Off Ver
    Excel 2013
    Posts
    1,714

    Re: Vba to display message when duplicate enteries are in the same row

    how do you want to identify the range to check for identical values?

    for example, this will check up to 5 columns before and after the activecell and display a message box if it finds a duplicate:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-29-2012
    Location
    Scotland
    MS-Off Ver
    Excel 2010
    Posts
    84

    Re: Vba to display message when duplicate enteries are in the same row

    I've attached an example. There are drop downs in row 9. If the user selects the same animal twice from column E:J I want the message box to appear. To let you understand I have the same drop downs further along the row.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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