Hi,
I have an input box where the user has to input a column
But i want an error to pop up if there's a number, or special character, or more than 3 characters (basically if the input value doesn't match a column)
Could you help?
Thanks!
Hi,
I have an input box where the user has to input a column
But i want an error to pop up if there's a number, or special character, or more than 3 characters (basically if the input value doesn't match a column)
Could you help?
Thanks!
Cant put this into code for you, but it should be something like =and(len(A1)<=0,istext(a1))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Can you provide the code you are using? I assume you mean an input box comes up during some code and you want to validate the input?
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Since you mentioned an Input Box, is this part of userform? Perhaps this helps as well
Please Login or Register to view this content.
If it is a userform, it is just as easy to just prevent any entries that are not letters, but if it is a true InputBox then it is likely not in a form...
xticnt, as you see we may need a bit more detail, but if my assumption about a true inputbox (which is called through code to request a value) is correct, you could try this:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks