I'm trying to validate against someone entering letters into an input box. Here is the code I have so far that doesn't seem to do work after I add the second part to verify if what they entered is numeric. I don't even the get input box anymore. As soon as I take it out, it works fine by poping up the box each time a 0 or a negative number is entered.
While carpetArea <= 0 And Not IsNumeric(CStr(carpetArea)) carpetArea = InputBox("Please enter the area that you want the carpet installed in:", "Area", "0") End While
I'm converting carpetArea from a double to a string so I can use it with isNumeric. Am I doing it wrong or is that somehow messing things up? Is there perhaps a better way? I have to use a input box so I can't don't have the option to do a text box.