only continue if number matches

Hi,

This should be simple... I think I'm over complicating it..

I need a piece of code that will check an inputted number against a column of numbers and if the inputted number doesn't match any of the numbers then a message will pop up saying "Account Number doesn't exist" and then after clicking OK it exits the sub... If the inputted number matches then continue with sub..

Please Login or Register  to view this content.

I know this is completely wrong but it's been a long day and my brain hurts noaccount goes to the end of the sub where the msgbox resides..

Cheers,

Thanks Badly,

Worked a charm

No problem. Happy to help

BSB