View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Substring check within VBA

Hi Dave,

I bet you were warning about instrrev???


Yes, I was Dave!

Thanks for the correction.

---
Regards,
Norman



"Dave Peterson" wrote in message
...
I think InStr has been there for a long time (forever??).

I bet you were warning about instrrev???



Norman Jones wrote:

Hi Gary's Sudent,

For xl2k == look at the InStr function in VBA help.

BTW, Why does Gary never give you an answer?

---
Regards,
Norman

"Gary's Student" wrote in
message
...
If Str1 and Str2 are strings, is there a function or simple coding
within
VBA
to return TRUE if Str1 is a substring of Str2, otherwise FALSE?

Thanks in advance
--
Gary's Student


--

Dave Peterson