Display values based on search

[mandukes]

I have set of data for a single search item.

Like..

For item no. 1
1.558 1.560 1653 0.5 OK
1.558 1.560 1219 0.5 OK
1.558 1.560 882 0.6 Reject
For item no. 2
1.787 1.789 1677 0.5 OK
1.787 1.789 1257 0.5 OK
1.787 1.789 927 0.6 Reject
For item no. 3
1.14 1.139 1172 0.5 OK
1.14 1.139 811 0.6 OK
1.14 1.139 547 0.8 Reject
For item no. 4
1.787 1.789 1677 0.5 OK
1.787 1.789 1257 0.5 OK
1.787 1.789 927 0.6 Reject


I need to display data in the textbox(es)from a worksheet name DBM3 on a click of a button!

I'm using application.Vlookup() method but can display only single Row, How to display other two rows.


there is a next button which should show all the items and its corresponding 3 set of data one by one.
File Attached.

Regards

Search&Display.xlsm

[V-B-A]

Hi mandukes,

See : Search&Display.xlsm

Code :

Please Login or Register  to view this content.

[TMS]

Maybe something like:

Please Login or Register  to view this content.

Regards, TMS

[mandukes]

Wonderful ! works perfect .. Thanks a million both of you

[TMS]

You're welcome. Thanks for the rep.

[V-B-A]

You're welcome