Skip, your a legend! Works perfectly.
However there is a catch.
Because I was comparing text against value the code could not find the account numbers - no problem I have created a text version of the account numbers to look against.
Happy Days
Many Thanks.
Mike.
There are over 12000 accounts. I don’t think that would be an option as it would take the user ages to find the number in the list.
Again apologies if I'm being a pain, really hope you can help!
The first IF statement ensures the user enters an account number so if its blank they get the MSG
"Please Enter Account Number"
I guess I was trying to use this code to then ensure the account number they entered is valid by checking it against a list of pre defined account numbers (Up to...
Following some advice i may of posted in the wrong place last time! :) This is a re-post.
Hello to all! My first post.
I have been looking over the internet for some hours now but I cannot find a solution to a problem I have.
I'm trying to validate an account number that a user inputs into a...
Hello to all! My first post.
I have been looking over the internet for some hours now but I cannot find a solution to a problem I have.
I'm trying to validate an account number that a user inputs into a text box on a userform (VB6).
This is by cross referencing against a list of pre-defined...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.