Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compare between String and Value using VBA
Dim myValue as string
If isnumeric(myValue) then .... end if if not isnumeric(myValue) then .... end if -- HTH... Jim Thomlinson "coco" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare string | Excel Worksheet Functions | |||
Compare text string of a cell in Column A VS another cell in Colum | New Users to Excel | |||
Compare text string of a cell in Column A VS another cell in Colum | Excel Discussion (Misc queries) | |||
Compare text string of a cell in Column A VS another cell in Colum | Excel Worksheet Functions | |||
string compare with wildcards | Excel Programming |