Hi I am very new to Excel/VBA. I have created a "JV INFORMATION SYSTEM" in excel and have designed a user form for users to enter new JV iNFO.

My next step is to design a Search or find form for viewing the JV Information where
user can choose to look up for JV info either by Company Name or Project Name or Date

The worksheet that stored my data is called "JV" . In the sheet "JV " I have following 10columns

Column A -No
Column B-Company Name
Column C Project Name
Column D- Start Date
Column E- End Date
Column F- Equity Ratio
Column G- Company Address
Column H-Contact Person
Column I-Contact No

I did see a few examples of look up forms but am struggling to customise them to suit me.

Ideally I need a combobox & textbox in search field. So user can choose the "Search by" category using combobox e.g. Company Name or Project Name or Date
and then enter the relevent text in the textbox to carryout the search.

and then use labels & listbox to display the related fields on the form. The reason I prefer labels is that I do not want users to edit the info. and listbox to show multiple results out of which user can choose specific one....e.g. when user does a search by Company, I want listbox to show the various Information about that company or when user search by date e.2 by Year , all information related to that year is display in the list box .

any help would be appreciated...thx in advance