How to check postal code format for user form text box

I'm hoping someone can help! I'm trying to create a data entry form using a userform. I've created a text box for Postal Code. In Canada, the format is A1A 1A1. I would like to validate that the person is entering the postal code in the right format when they are using the user form. I've stumbled on how to do it within the worksheet source code (http://www.excelforum.com/excel-prog...-on-entry.html), but there must be a way to do it when I initialize the user form? I'm using Excel 2010.
Any help??

Use it as a function to evaluate valid or invalid.

Please Login or Register  to view this content.

Sorry, you've lost me.... I'm new to this...

My txt box is call txt_pc, how do I incorporate this with what you've given me!

Thanks a bunch for replying!

Something like this
To A UserForm module

Please Login or Register  to view this content.

1) You need to edit your last post and wrap the vba code with the code tag.
It's a MUST rule here.
i.e
[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]

2) Not tested.

Please Login or Register  to view this content.

Thanks Jindon.

I tried the code above, but it seems to not recognized the function IsValidPostCode. It allows me to enter the Postal Code, but it doesn't matter what I enter, it keeps coming up Invalid Entry. I'm sure it's simple, it seems so close!!!!

Any suggestions?

Originally Posted by jindon

1) You need to edit your last post and wrap the vba code with the code tag.
It's a MUST rule here.
i.e
[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]

Post your workbook.

Book1.xlsm

Thanks!

...................

Hi Jindon,

The xlsm file that you attached does not seem to work either. When I enter the postal code with the UserForm button in any format, it all comes back with invalid entry. The correct format should be A1A 1A1, but even when I enter that, it comes up as unvalid? Maybe I am doing something wrong?

Thanks again!

That's great Jindon! Can I see the code so that I can learn what you did?

Nope.

You must edit your post #5 first.

Sorry for my ignorance, I don't know what that means. As I said, I'm new to this, so if you could explain, that would be great!

1) Click on [Edit Post].

2) Select vba code in that post and click on "#" in the menu. It will add code tag automatically.

Please Login or Register  to view this content.

Password removed.

Thanks again Jindon! One more thing, any idea how I can enforce uppercase letters?

Add this to a Form module

Please Login or Register  to view this content.

Hi Jindon,

One last thing, if I want to enforce the space between, would I change the function to this:

Please Login or Register  to view this content.

When I try this, it doesn't work?

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Thank you so much Jindon for all your help and patience! I've learned so much! Hope others will see this as valuable as I did!!