Userform for canadian postal code validation?

Hi,

I would like to know how to validate if a textbox is entered, if and reach condition, then that postal code will be move to another textbox2:
If TextBox1 = LETTER NUMBER LETTER SPACE NUMBER LETTER NUMBER Then
TextBox2 = TextBox1
Else
MsgBox ("THis is not a valid canadian postal code")

Can anyone help on this?

Thanks.

that works, but how if I want to integrate an right(textbox1.text),7?
Example:

If entered more string in the textbox1, it will only capture the last 7 string and from there it does the validation.

Nice, I made a mistake in it by adding the ,7 after the bracket, thats why it didnt work.

THank you so much!