search another worksheet for textbox value and display results on listbox (without form)

Hiii guys..

I'm trying to do this VBA code for over 2 weeks now, but no luck at all.
then i found this perfect foum of yours, then i guessed i can get some help from experts.
anyways, I've red a post earlier to do the same thing but with a form.
all i need now is to search "sheet2" which contains some companies invoices and bills and make the searched company row appear in the" listbox" in "sheet1". WITHOUT ANY FORMS!!.

help me plz !!

thanks for any help in advanced ..

a sample of excel file attached

Peace

I'm not clear on what you're trying to do.
How do you know what the searched company row is?
Or are you saying you want to have a drop down list of company names in Sheet1 that can be selected?
Maybe if you give an example of the output you're expecting.

Still not entirely clear.
Where will you enter the search parameters? In the textbox about the Search button on Sheet1?
Are you going to put in some search identifier (like Company = ACC) or will you only put in the company name and expect the macro to determine what that value is?
What information do you want returned?
Where do you want to have the information put? In the textbox below the Search button on Sheet1?
What happens when you have more than 1 line of data to return?