Validate ID# and Employee#

[fabian_76]

HI atttached is a file with information that I want to validate such as ID# and Employee#.

If they do not match, user should not be allowed to register their entry.

Can someone please help me?

Thanks

[jindon]

Try

Please Login or Register  to view this content.

[fabian_76]

Thank you Jindon, I tested it but did not work.

[jindon]

I tested it but did not work.

This doesn't help.

How is it not working?
Did you pasted the code on to Sheet code module?

[fabian_76]

Yes, and put in Column B as example 110 twice as ID and two names in Column B but message never came up

[jindon]

Working..................

[fabian_76]

JIndon, I see what is going on. User should be informed as long as the names he enteres in ColB are different, e.g. Luis and Carlos.

Right now it works if I put e.g Luis and Luis.

Can you please help?

[jindon]

I see, I misread the problem...
Try change to

Please Login or Register  to view this content.

[fabian_76]

Thank you so much! It worked