using excel 2003.
To be frank with you I m not familier with vba.
I have one excel data file. In those file i have following data record.
column a : applicationcode
column b : partno
column c : description
column d : remark
column h : qty
Right now i have search only one base category & one search terms.
(used leith ross readymade file) as per thread "Search through database and display results in userform " http://www.excelforum.com/excel-prog...-userform.html
here i really thanks to leith ross soltion.
Actually i required two category & two search terms.
For example: If In first search category if i have select "Header 1" & enter in search term : "02.2115" (applicationcode) & another search category if i have select "Header 3" & enter in search term : "piston" (description).
To Display in search result :
applicationcode
partno
description
remark
qty
And my other problem is after right click on sheet1 & select "view code" the program not show. Explain about not viewing program.
I have attahed sample file for your reference.
Bookmarks