+ Reply to Thread
Results 1 to 5 of 5

Need help to create a checker macro

  1. #1
    Registered User
    Join Date
    04-09-2019
    Location
    India
    MS-Off Ver
    2016
    Posts
    13

    Need help to create a checker macro

    Hi friends,

    I wanna create a checker macro where in a row with Column names G1 M1, G2 M1 & G3 M1 (1st column of each group) should not contain same names. same like that need for M2s and M3s as well.

    Please find attached the excel file for more clarity. have marked red in the rows where names are appearing twice or more in the respective M(s) of each group.

    The macro should not allow a user to enter duplicate values in the above mentioned manner.

    Say for instance a person named Sam , can enter his name in G1 M1, G2 M2/G2 M3 , but should not enter in G1 M1 , G2 M1/G3 M1

    kindly help

    thanks
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: Need help to create a checker macro

    Why not just use conditional formatting? For example, highlight B3:D4 and make the condition:
    =OR(B3=F3, B3=J3)
    Pauley
    --------
    If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).

  3. #3
    Registered User
    Join Date
    04-09-2019
    Location
    India
    MS-Off Ver
    2016
    Posts
    13

    Re: Need help to create a checker macro

    Quote Originally Posted by Pauleyb View Post
    Why not just use conditional formatting? For example, highlight B3:D4 and make the condition:
    =OR(B3=F3, B3=J3)
    Hi Paul, thanks for the input. Tried the idea which you pointed out. Its highlighting the duplicates. But wot I need is no user should be allowed to enter duplicates. Some kind of pop up message like " Duplicate entry - please re-enter" shud come.. similar to the data validation function.

  4. #4
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    2,274

    Re: Need help to create a checker macro

    Possibly using the sheet's change function...
    Please Login or Register  to view this content.

  5. #5
    Forum Expert
    Join Date
    06-26-2010
    Location
    Austin, TX
    MS-Off Ver
    Excel 2010
    Posts
    1,673

    Re: Need help to create a checker macro

    Well, you could then use Data Validation using the same technique as above, except your formula would now be
    =NOT(OR(B3=F3, B3=J3))

+ 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. Row checker but only certain columns
    By samcatbread in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-20-2017, 12:53 PM
  2. Disable Compatibility Checker in macro
    By TimmerSuds in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-11-2017, 11:09 AM
  3. hyperlink checker VBA
    By blgross07 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-08-2013, 01:01 PM
  4. Sequential Checker
    By marcusmark in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-30-2011, 03:22 AM
  5. Spell Checker Macro
    By henrythompson in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-05-2010, 07:28 PM
  6. [SOLVED] Spell Checker
    By Gordon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-28-2005, 11:53 PM
  7. Spell checker
    By help with microsoft site in forum Excel General
    Replies: 1
    Last Post: 06-27-2005, 11:05 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