Need VBA help for excel

Hi, could anybody please write a vba code for creating text format?
ex: the cell should be of 11 digits which first 4 digits should be alphabet followed by 0 and rest of the digits are numeric (SBIN0123456). If anything typed wrong should be alerted with error message.