Question??Searching form
 

I have one form, by this form i inserting data to table in one excell
sheet. I would like to create search form, which will be search trough
this table and find lines with data which i will request trough my own
formular and then it will read line by line and show data from lines
into formular. Anyone know ho do it ?


--
frankosun
------------------------------------------------------------------------
frankosun's Profile: http://www.excelforum.com/member.php...o&userid=29566
View this thread: http://www.excelforum.com/showthread...hreadid=492648

Question??Searching form
 

set table = Range("B11:T20")
res = Application.Find("myvalue",Table.columns(1),0)
if not iserror(res) then
with Userform1
.Textbox1.Text = Table.Item(res,1)
.Textbox2.Text = Tabel.Item(res,2)
End With
End if

might be a start

--
Regards,
Tom Ogilvy


"frankosun" wrote
in message ...

I have one form, by this form i inserting data to table in one excell
sheet. I would like to create search form, which will be search trough
this table and find lines with data which i will request trough my own
formular and then it will read line by line and show data from lines
into formular. Anyone know ho do it ?


--
frankosun
------------------------------------------------------------------------
frankosun's Profile:
http://www.excelforum.com/member.php...o&userid=29566
View this thread: http://www.excelforum.com/showthread...hreadid=492648

Question??Searching form
 

Thanx for your help, i will try it and i will let you know, but many thanx
for your help.
regards

frankosun

Tom Ogilvy pÃ*Å¡e:

set table = Range("B11:T20")
res = Application.Find("myvalue",Table.columns(1),0)
if not iserror(res) then
with Userform1
.Textbox1.Text = Table.Item(res,1)
.Textbox2.Text = Tabel.Item(res,2)
End With
End if

might be a start

--
Regards,
Tom Ogilvy


"frankosun" wrote
in message ...

I have one form, by this form i inserting data to table in one excell
sheet. I would like to create search form, which will be search trough
this table and find lines with data which i will request trough my own
formular and then it will read line by line and show data from lines
into formular. Anyone know ho do it ?


--
frankosun
------------------------------------------------------------------------
frankosun's Profile:
http://www.excelforum.com/member.php...o&userid=29566
View this thread: http://www.excelforum.com/showthread...hreadid=492648