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

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

"Roman Töngi" wrote in message
...
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