numeric

[oleg_v]

hi
how can check with the help of vba if cells value is numeric or not?

thanks

[lehgzil]

hi,
i use something like this
[VBA]Private Sub Worksheet_Change(ByVal Target As Range)
'lets say your cells value is on sheet1 @ cell a1
If Not IsNumeric(Sheets("sheet1").Range("a1").Value) Then
MsgBox "not number"
End If
End Sub[/VBA]
on the sheet module.
hope this helps.