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 ?

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" <frankosun.1zx3qq_1134375055.9988@excelforum-nospam.com> wrote
in message news:frankosun.1zx3qq_1134375055.9988@excelforum-nospam.com...
>
> 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
>

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" <frankosun.1zx3qq_1134375055.9988@excelforum-nospam.com> wrote
> in message news:frankosun.1zx3qq_1134375055.9988@excelforum-nospam.com...
> >
> > 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
> >
>
>
>