Entering and formatting UK Postcodes into UserForm TextBoxes
Has anyone had any success with trying to validate a UK Postcode into a Userform TextBox entry? I've scoured the internet and am now more confused than before I started...
As a last resort I was thinking of allowing the entry of a string of letters and numbers, limited to 8 characters (including the space), and inserting the space before the 3rd character from the right once the TextBox is tabbed out of?
Would that work?
How would that be coded?
My head is fried......
LOL
It is never that easy
Format
A9 9AA
A99 9AA
AA9 9AA
AA99 9AA
A9A 9AA
AA9A 9AA
Last edited by mehmetcik; 08-09-2018 at 03:26 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Ok,
Can you please explain how to code the following formula into VBA, assuming it can be done. I've tried copying a recorded Macro but keep getting the "Type Mismatch" error message every which was I play around with it.
The formula is,
Please Login or Register to view this content.
Well I had a think and a beer and came up with this, seems to work ok,
Had to put in two textboxes (hidden) to split the postcode up, amended the last three characters to add a space before them and then concatenated them back into the original TextBox.
I even surprised myselfPlease Login or Register to view this content.
How about this ? Without the extra textboxes.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
TryOriginally Posted by AndyE
Ok,
Can you please explain how to code the following formula into VBA, assuming it can be done. I've tried copying a recorded Macro but keep getting the "Type Mismatch" error message every which was I play around with it.
The formula is,
Please Login or Register to view this content.
Please Login or Register to view this content.
Your first question was to validate a UK Postcode into a Userform TextBox entry...
what about using a Regular expression like this :
(got the idea here)Please Login or Register to view this content.
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
Wow! thanks all for the responses.
Apologies GC, That's brilliant, I did say validate when formatting might have been a better word, only since I wouldn't even know where to being to attempt to try and do that & the code you've supplied.....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks