Compare between String and Value using VBA
What VBA function can I use to implement a conditional IF like this:
Dim myValue as string
If (string VALUE is TEXT) then
....
end if
if (string VALUE is VALUE) then
....
end if
examples:
string value can be like :
A1
ABC34
XYZ1234
string value as value (only numbers):
12
345
67
Thanks
Coco
|