+ Reply to Thread
Results 1 to 3 of 3

Message box display after using conditional formatting to identify duplicate values

  1. #1
    Registered User
    Join Date
    10-03-2016
    Location
    England
    MS-Off Ver
    2013
    Posts
    2

    Message box display after using conditional formatting to identify duplicate values

    Hello,

    I have recorded a macro to highlight duplicates cell values in column F:F in sheet 1 and and Column F:F in sheet 2. I would like to have a message box displayed at the end of running macro to show which sheet has a duplicate value.

    Please help.

    Thanks in advance.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello Uzis123,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    10-03-2016
    Location
    England
    MS-Off Ver
    2013
    Posts
    2

    Re: Message box display after using conditional formatting to identify duplicate values

    Thank you arlu1201

+ 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. Conditional Formatting and Duplicate Values
    By bgarner10 in forum Excel General
    Replies: 2
    Last Post: 01-01-2016, 09:18 PM
  2. Sorting on duplicate values (Conditional Formatting)
    By davecut85 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-15-2015, 06:01 PM
  3. [SOLVED] Help with Conditional Formatting Duplicate Values
    By alcharbonneau in forum Excel General
    Replies: 6
    Last Post: 02-26-2013, 09:09 PM
  4. Conditional formatting for duplicate values
    By kris26 in forum Excel - New Users/Basics
    Replies: 12
    Last Post: 03-21-2012, 06:51 AM
  5. Ignore Duplicate Values In Conditional Formatting
    By mightyeskimo in forum Excel General
    Replies: 13
    Last Post: 09-18-2010, 01:28 PM
  6. Replies: 1
    Last Post: 08-18-2010, 02:00 PM
  7. Conditional Formatting- Highlight Duplicate Values
    By Christopher_1 in forum Excel General
    Replies: 4
    Last Post: 04-21-2010, 11:02 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