jQuery/JavaScript Java VBA

You pass an object (text field) to the function. It will return true if the value of the field is a currency or a number.

function isValidNumber(obj){
val = obj.value;
cur = /^-?\d{1,3}(,\d{3})*(\.\d{1,2})?$/;
anum=/(^-?\d+$)|(^-?\d+\.\d+$)/;
ret = false;
if(val.indexOf(",")>-1)
ret = cur.test(val);
else
ret = anum.test(val);
if(!ret){
alert("Invalid number format");
return false;
}
else
return true;
}