Case statement for validating textbox

[BUGold04]

I have a SSN field. I want to display an error message upon submitting the page if the user has entered something like "111111111" or "222222222",etc...up to 9. Also I want to reject "123456789".

Would the correct way be to write

If txt_SSN.text = "111111111" Then
app.msgbox "error message"
txt_SSN.SetFocus
ValidateCustomer = False
Exit Function

And how could I make this into a case statement for the others?

Thanks for any help

[PeOfEo]

http://www.programmershelp.co.uk/vbselectcase.php
hope this helps.