Hello All,
I have a Useform with a textbox where I would like to input the Canadian Postal Code with this format XXX XXX, Please notice there is an space in the middle. How could I input caracters and the checkbox recognize it has to put an space in the middle and only able to type 6 caracters (letters and numbers)
Thank you in advance
Regards,
Last edited by eddyrcabrera79; 12-04-2013 at 03:00 AM.
Hello eddycabrera79,
This example assumes the name of the TextBox is "TextBox1". This limits the user input to six characters and then inserts a space.
UserForm Code
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hello,
See if this helps
This code is for a textbox1 modify to match your textbox name.Please Login or Register to view this content.
Thanks
By the way Leith just reminded me I forgot something. the initial value for the maxLength.
Thanks Leith
So this is my final code with everything:
ThanksPlease Login or Register to view this content.
Thank you Leith and Fredlo for your help.
This code worked fine for me
Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
TextBox1.Text = Left(TextBox1.Text, 3) & " " & Right(TextBox1.Text, 3)
End Sub
Private Sub UserForm_Initialize()
TextBox1.MaxLength = 6
End Sub
I forgot one thing, the Canadian Postal code is a combination of numbers and letters in this way M1M 1M1, Is there a way to resctirc the entry to this format?
Last edited by eddyrcabrera79; 12-04-2013 at 02:52 AM.
Thank you Leith
This code worked fine for me
Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
TextBox1.Text = Left(TextBox1.Text, 3) & " " & Right(TextBox1.Text, 3)
End Sub
Private Sub UserForm_Initialize()
TextBox1.MaxLength = 6
End Sub
I forgot one thing, the Canadian Postal code is a combination of numbers and letters in this way M1M 1M1, Is there a way to resctirc the entry to this format?
Hello see if this helps,
ThanksPlease Login or Register to view this content.
thank you so much
You are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks