I'm trying to get input from a user regarding parameters for loan calculations. I'm still very new at VBA so some of this will seem very silly, but I've been trying for hours to get this to work right and I keep fixing problems and creating more simultaneously. I've come to the conclusion that I have a fundamental misunderstanding of how this works.
This one actually works fine, but I am including it just in case I've done something less than perfect and someone can correct it.
This one works if I input a number, but I'd like to be able to have the validation also check for a $ and automatically trim it off. I've got it checking for cancel already but I want this input validation to catch everything and ask for corrected input on anything except $xxxx, $xxxx.xx, xxxx.xx, or xxxx (any amount of digits, not just thousands).
I'm not really sure what else to ask at this point. I've been searching google and these forums for a while but I can't find much in the way of examples for robust input validation.
Bookmarks