Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching for a request form | Excel Discussion (Misc queries) | |||
Searching by an User Form | Excel Worksheet Functions | |||
Searching in a user form / List box | Excel Programming | |||
searching excel with a form and returning the results | Excel Programming | |||
Searching a spreadsheet using a vba form | Excel Programming |