Re: Help:Find and Display

From: kenrose08 <kenrose08.2cgnaw_1155442211.7082@xxxxxxxxxxxxxxxxxxxxx>
Date: Sun, 13 Aug 2006 00:08:02 -0400

Thank you Sir,
this is so much help.

*just another question*.
what if the data i want to search is not in the list,
how do i code it?

*thanks*!

Tony James Wrote:

TextBox2.Text = TextBox2.Text & Sheets(1).Range("B" &
result.Row).Value & vbCrLf

spotted a typo above: result.Row should be resultRng.Row

--
kenrose08
------------------------------------------------------------------------
kenrose08's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=22317
View this thread: http://www.excelforum.com/showthread.php?threadid=570977

.

Follow-Ups:
- Re: Help:Find and Display
  - From: Tony James

References:
- Help:Find and Display
  - From: kenrose08
- Re: Help:Find and Display
  - From: Tony James
- Re: Help:Find and Display
  - From: Tony James

Prev by Date: Re: Deleting unwanted data by macro or...
Next by Date: Re: Application.DisplayAlerts = False
Previous by thread: Re: Help:Find and Display
Next by thread: Re: Help:Find and Display
Index(es):
- Date
- Thread