Hi everyone,
I have a textbox on my userform called "SerialTxt" what i am wanting to do is when a user enters an alphanumeric number with special characters "-" i want that textbox to check cell "P1" on a worksheet called "Data". If the value is the same then allow the user to continue, if the value does not match cell "P1" then a MsgBox will say "Invalid Number". clear the contents of the textbox and allow them to try again.
Hope this is easy to understand.
Thankyou
I have a textbox on my userform called "SerialTxt" what i am wanting to do is when a user enters an alphanumeric number with special characters "-" i want that textbox to check cell "P1" on a worksheet called "Data". If the value is the same then allow the user to continue, if the value does not match cell "P1" then a MsgBox will say "Invalid Number". clear the contents of the textbox and allow them to try again.
Hope this is easy to understand.
Thankyou