View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
gti_jobert[_17_] gti_jobert[_17_] is offline
external usenet poster
 
Posts: 1
Default Search String within String


Would this work, have wrote the code but cant test it yet as form is not
built;


Code:
--------------------

i = 1
Do
If InStr(1, Cells(i, 1).Value, txtSearchString.Text) = True Then
'display numbers in datagrid
End If
i = i + 1
Loop Until Cells(i, 1).Value = ""

--------------------


--
gti_jobert
------------------------------------------------------------------------
gti_jobert's Profile: http://www.excelforum.com/member.php...o&userid=30634
View this thread: http://www.excelforum.com/showthread...hreadid=512651