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

--
Tim Zych
www.higherdata.com
Compare data in workbooks and find differences with Workbook Compare
A free, powerful, flexible Excel utility


wrote in message
...

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