Here's some old code from Tom Olgivy

Dim rng as Range
set rng = Cell.find( Targetvalue)
if not rng is nothing then
' found
' do something
else
' not found
End if


see if this gets you going...

--
steveB

Remove "AYN" from email to respond
"Syed Haider Ali"
<Syed.Haider.Ali.1u4j6k_1124643937.6135@excelfor um-nospam.com wrote in
message news:Syed.Haider.Ali.1u4j6k_1124643937.6135@excelf orum-nospam.com...

Hi Dears,

In FoxPro to find the record we use just like the following commands.
(and if found the record then rest of the fields shown in Textboxes of
the userForm)

Locate for xyz=mxyz

if .not. found()

wait wind "Record does not exist"

else

Field1=textbox1
Field2= Textbox2


I need the codes for Excel vba, To find the record and if found then
show the fields of the table in Textboxes of UserForm


Thanks in advance


--
Syed Haider Ali
------------------------------------------------------------------------
Syed Haider Ali's Profile:
http://www.excelforum.com/member.php...o&userid=21994
View this thread: http://www.excelforum.com/showthread...hreadid=397584