What you did is what you meant - I was just representing if the criteria was
not passed, then set cancel = true - which is the way you wrote your code.

Regards,
Tom Ogilvy

"steve bell" wrote in message
...
Tom,

As always - you came through AND so quickly!
Thank you!

My ignorance is showing as I used the following:

Private Sub TextBox54_BeforeUpdate(ByVal Cancel As
MSForms.ReturnBoolean)
Dim phn
phn = TextBox55
If Len(phn) < 7 Or Len(phn) < 10 Then _
Cancel = True

End Sub

wasn't sure how to use:
if "not validated" then _
Cancel = True

steve

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!