Validation for Textbox in Userform

[shahzad4u_ksa]

Dear Sir,

I prepared one Userform, I want to validate the text field like this.

SEP<SPACE> 08 i.e. SEP 08 in capital letters.

what is the code for this purpose.

Waiting for your response..

Best Regards.

Syed Shahzad Zafar

 

[Tim Zych]

If textbox1.text Like "[A-Z][A-Z][A-Z] ##" then
' match
else
' try again
end if

 

[Rick Rothstein \(MVP - VB\)]

I am pretty sure there is more to your question than you have posted, but to
answer the question you asked...

If TextBox1.Text = "SEP 08" Then
MsgBox "Valid entry"
End If

Just to take a guess at what your ultimate question may be, is the "SEP" an
abbreviation for a month? If so, and if you want to check that the input is
a 3-character for an actual month, consider this...

For X = 1 To 12
If TextBox1.Text = UCase(MonthName(X, True)) Then
MsgBox "Valid entry"
Exit For
End If
Next

Rick