I made a program that allows users to input in a cell B6 to E6, B7 to E7, B8 to E8. I want to catch non numeric characters and empty input. It will pop-up an error message and will not allow users to input in other cells.
For example the users input numbers in B6, C6, D6 but in E6, he encoded non-numeric character, excel will pop up an error and he can't encode in other input cells as long as he didn't correct the input.
Show us what you made
Last edited by patel45; 01-12-2013 at 07:02 AM.
If solved remember to mark Thread as solved
HI Perdix,
See the attached file where I have used data validation to achieve desired results.. let me know if this helps. thanks.
catch non numeric.xlsx
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
This helps thank you! Can you attach the codes you used? Or teach me how to do it?
As I mentioned I have used data validation not code.. select any cell and press Alt + D + L, you'll see the formula there
Regards,
DILIPandey
<click on below * if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks