Hi Daniel,

Thank your your reply. I must be doing something wrong. It
does not work on Excel 97 even with []. I will test it on
Excel 2k tonight. Thanks again for your help.

-----Original Message-----
Hi,

This worked OK for me:-

Sub ValidateText()

Dim x

x = InputBox("Enter text")

If x Like "###/####-[A-Z]" Then
Debug.Print "Valid"
Else
Debug.Print "Invalid"
End If

End Sub

If you can't get this to work then you could try
surrounding the / and - in
square brackets [ ].

Regards,
Daniel

http://www.danielklann.com


"Jamie" wrote in
message
...
Hi All,

I want to put the following format as a requirement for
data entry via a userform:

123/4567-K

three numbers, a slash, four numbers, a dash follwed by
a
letter.

I have tried ###/####-[A-Z]. It seems that I can not get
the slash and the dash. I am not sure of their format in
VB. Any help is appreciated. Thank you in advance.


.