VBGamer
RE: Err...DOH! Adam Hoult (4 replies, 0 views) (2000-Jul-7)
Ooops sorry, I read it that you wanted to check the variant type.
Anyway you could do something simple like this
If Val(MyVar) <> MyVar Then MsgBox "NotNumber !!"
Thats straight off the top of my head btw, and isn't the most efficient way of doing it due to two lots of type changes, but it's an easy way to do it.
Adam
 | RE: Err...DOH! Mattman (3 replies) (2000-Jul-7)
| ||||||||||||||||||||||||
 | | RE: Err...DOH! Adam Hoult (2 replies) (2000-Jul-8)
| |||||||||||||||||||||||
 | | | I guess I'll give it another shot! *nt* Mattman (1 reply) (2000-Jul-8)
| ||||||||||||||||||||||
| | | | RE: I guess I'll give it another shot! *nt* Adam Hoult (0 replies) (2000-Jul-8)
| |||||||||||||||||||||
