I want to check that the information a user enters into the input box prompt is only uppercase and numbers. If it meets this criteria then the program continues otherwise it gives and error msgbox that prompts them with the correct formating until a correct entry has been made? any idea how to do this?
Example removed; I provided a better example in the next post
Last edited by 6StringJazzer; 10-10-2011 at 03:53 PM.
Here is something more specific to your question, that loops until the right answer is given.
Please Login or Register to view this content.
Re: Check to see if input box content is uppercase
hmm... try this out (see attached to run the macro and step through to see what's it's doing:
Needed a little more code to do this...found a way to loop and repeat the query until the input is OK
Enjoy and rate please
Please Login or Register to view this content.
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
guess mine is kinda ugly...but the general principle is good. I just used an array to spell out exactly what characters are OK and all others are not...may be a better way to test "alpha-numeric-ness" of input but this seems to work.
Please see my example posted above yours.Originally Posted by GeneralDisarray
but, he wanted uppercase letters and numbers right? what about the numbers?
also, when i tested your reply, the loop exits with non-alpha characters. FOr example "&&&THE&&" is not kicked back.
Last edited by GeneralDisarray; 10-10-2011 at 04:08 PM.
Another way:
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
o_0 dang...that is the empitamy of slickness
Uppercasing a string leaves the numbers alone, so you don't have to check for them explicitly.
However, I made a mistake in forgetting about special characters. If special characters are not allowed then my solution doesn't work. The following code corrects this:
shg's solution using regular expressions is quite nice, although in this case Like provides economy.Please Login or Register to view this content.
Last edited by 6StringJazzer; 10-10-2011 at 09:14 PM. Reason: changed "Until Not" to "While" though both are equivalent
If you dont mind puncuation and suchis a quick and easy test.Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
See post #3 and ensuing discussion....
I would recommend 6SJ's Like method in preference to my RegExp.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks