I have a TextBox for which I want to control the user input for UK postcodes, in the following format "[A-Z][A-Z][0-9][0-9]<space>[0-9][A-Z][A-Z]"
I have seen numerous variations of code which apparently does this but I can't it to work, usually around..
I've tried the above in the TextBoxPostcode_Change(), TextBoxPostcode_AfterUpdate(), and UserForm_Initialize() events to no avail. I've also seen the above string represented as "LL00 0LL"Please Login or Register to view this content.
Is there an easy way to do this?
Bookmarks