Input Mask for TextBox

[AndyE]

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..

Please Login or Register  to view this content.

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"

Is there an easy way to do this?

[macropod]

I posted a solution for this a week ago, but now it's gone. Here's another one:

Please Login or Register  to view this content.

Note that the code automatically inputs the space for you.

[Kyle123]

Andy, do you want all valid UK postcodes or just the ones that confirm to that format? There are plenty of valid ones that are not in the format you describe, for example S75 2DY, EC1V 7EB, GIR 0AA. If you want all valid ones, then unfortunately Paul's suggestion won't work - if you don't then great

Here's a function with the official regular expression - note that all letters must be capitals and there must be a space:

Please Login or Register  to view this content.