I know this is an easy one but I wa

[simoncpage]

I know this is an easy one but I want to check a string if it contains a certain symbol "_" ???

 

[xlbo]

Probably an easier way but:

For i = 1 to len(myString)
vs = mid(myString,i,1)
if vs = "_" then
-----do stuff
else
-----do other stuff
end if
HTH
Geoff

 

[JustinEzequiel]

if instr(1, StringToCheck, "_&quot then
msgbox "your string contains '_'"
else
msgbox "you string does not contain '_'"
endif

 

[simoncpage]

Thanks istr is the function that I just couldnt rememeber cheers!