Validate users entry against a list held in another worksheet

[MIFF3436]

Hi all,

In my workbook i have a few cells where users manually type in serial numbers. Is there a way that every time a user enters a value in any of these cells i can use the worksheet change to run a macro that will validate the user entry against a list of serial numbers in another worksheet. If the value matches one from the list 'do Nothing' but if the value is not recognized it will trigger a MsgBox to let the user know the value entered is not allowed.


Thanks

Miff3436

[karedog]

Maybe :

Please Login or Register  to view this content.

[MarvinP]

Hi Miff,

This is exactly what Data Validation does. You simply need to use it.

https://support.office.com/en-us/art...6-EFF3CE5F7249

[MIFF3436]

Hi MarvinP

Thanks for the response. This is more a proof of concept for something I wanted to try. I do use the data validation in general and drive user behaviours using functions like drop downs and character length etc..... I just wanted to know if there was a way for the user to enter manually instead of scrolling through a drop down that could have up to 6000 numbers in.

Your code is perfect for what I was looking to achieve. Your help is much appreciated.

Thanks
Miff3436

[karedog]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.