VBA: IsNumeric Function Returning True Even If Data Contains Letters. Any Other Way To Validate Entry?

[kelly mort]

I am using an inputbox to assign value(s) to my variable. After that I use the IsNumeric Function to check if the entry is a valid number.

During the testing process, I realized that I mistakenly entered 4e4 and instead of the function flagging that out as an invalid number, it went through as a number.

I have tried replacing the e with other letters and they were caught by the function yet the e always goes through when it comes between two numbers.

Is there a better way to validate my input?

Thanks in advance.

 

[kelly mort]

Yes it is.

I didn't have the issue though.
The only issue I observed was the commas.

 

[Alex Blakenburg]

I didn't have the issue though.
The only issue I observed was the commas.

I think we are at cross purposes here. I was replying to your question about the Instr method posted by bebbo being case sensitive.

 

[kelly mort]

I think we are at cross purposes here. I was replying to your question about the Instr method posted by bebbo being case sensitive.

Yes it is the same post I was referring to.

When I entered 4e4 and 4E4, they both got flagged as invalid numbers.

Bebbo's code. And the code did handle decimals and commas, but just like with the case of your version with the comma, inputs like 2,3 were accepted - which I don't want to accept as valid numbers.