What I need is for this field in my userform to only allow 5 digit numbers, no more, no less, no letters, no special characters. Must be a 5 digit number.
I know I can limit the field to 5 chars with MaxLength in the properties but how do I enforce a minimum and make it numeric only?
Thanks in advance!
Last edited by nohero; 06-03-2011 at 10:50 AM.
You could use a spinbutton min 10000, max 99999, showing the result in a textbox:
or you can use a combobox, type dropdownlist:
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by snb; 06-03-2011 at 10:31 AM.
To validate a textbox to only contain 5 digits...between 00000 and 99999, inclusive...
Create a function to test the contents
• Paste the below code into a General Module:
Please Login or Register to view this content.
Then...Use this code for the Exit event of your textbox
(change the control name to match what you used):
Please Login or Register to view this content.
Now...Upon exiting your textbox, the validation code will engage.
If the input is not 5 digits, it will be erased and a warning will display.
Is that something you can use?
Last edited by Ron Coderre; 06-03-2011 at 10:01 AM.
@Ron,
In your approach wouldn't this be sufficient ?
Please Login or Register to view this content.
Untested, but....I think that code would allow "1.234"Originally Posted by snb
wouldn't it?
@Ron,
Quite right, but
Please Login or Register to view this content.
I tweaked my code to have it actually erase the invalid entry
and to use a more concise regular expression:
Please Login or Register to view this content.Please Login or Register to view this content.
Hi nohero,
Find the attached that may do what you want. After lots of playing around with a TextBox1 on a userform and events this may do what you want. Click the button to show the userform and then you can't get out of the first textbox unless it is 5 characters long and it is a number.
You need to go to VBA and look at the code behind the Userform to see what it is doing.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Did you ever get your mind headed down the wrong path and have trouble getting back on track? Well, that's what happened to me.
This code seems to work just fine:
...and it doesn't use any regular expressions...just native VBAPlease Login or Register to view this content.
Thanks for the suggestions guys, I didn't try your first post snb because I wasn't sure that it would accept a number that begins with a zero and these serial numbers very well could.
I took Ron's first code and added it to my list of checks, I also added a vbNullString command at the end so I already have it clearing the field.
Works like a charm, you guys are great!
hey noHero-
As far as I know there is no way to do a min by Properties Method. You will have to write a Macro to handle the input. If you need help with that let me know.
Well I now see it could have been easier but why mess with what works? It's working as intended now and I'm far from an expert so even though my code is starting to get really messy I don't want to disturb something important that I don't understand (just copied from elswhere).
So far so good, you guys are a HUGE help!
Hi I have just found this side and this code looks exactly what im looking for except the first 4 characters will be A-Z (PGOS will be exact text) then there will be 6 further numbers).
Is is possible your code could work like this?
.Pattern = "[P][G][O][S][0-9][0-9][0-9][0-9][0-9][0-9]"
Or
.Pattern = "[A-Z][A-Z][A-Z][A-Z][0-9][0-9][0-9][0-9][0-9][0-9]"
To validate a textbox to only contain 5 digits...between 00000 and 99999, inclusive...
Create a function to test the contents
• Paste the below code into a General Module:
Please Login or Register to view this content.
Then...Use this code for the Exit event of your textbox
(change the control name to match what you used):
Please Login or Register to view this content.
Now...Upon exiting your textbox, the validation code will engage.
If the input is not 5 digits, it will be erased and a warning will display.
Is that something you can use?
alantee,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
Don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding.
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks