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