if char is number

[Roman Töngi]

How can I determine whether a char is a digit or a period by menas of VBA?
Example:
If char = 0 or char = 1 ... or char = 9 or char = "." Then
...

There is sure to be a shorter solution.

Regards,
Roman

 

[Sharad Naik]

If IsNumeric(char) Then

Sharad

 

[Tom Ogilvy]

? isnumeric(".")
False
? isnumeric("5")
True


so
if Isnumeric(char) then
msgbox "It can be treated as a number"
else
msgbox "it can't be treated as a number"
End if

 

[Sharad Naik]

Actually it should be
If IsNumeric(char) Or char = "." Then

in case you want to check if char is only a dot.
Sharad

 

[Tom Ogilvy]

My answer was incomplete as well. If you want to check if Char is a period
you would have to check that explicitly. However, if your use of char is
actually misleading and you want to check if a string is a number

char = 123.45

then Isnumeric(char) would be true.

if char ="A1123"

then isnumeric(char) would be false

 

[Roman Töngi]

just what I looked for,
thanks