Hi Leith;
Your form works pretty well.
But I need it modifed.
I have tried a lot but not able to do so.
I want only the following.
User selects a criteria from the combobox(Column 1 ro 13, Row 1)
User types text in search field and then hits the search button
In the list box all the results are listed. For each result there is only one single row.
The top row of the listbox displays the 1row of the sheet.(That I can do)
The results are displayed one below the other. So that the user need not use "prev" and "next".
And the most important is when there are no results,a message box must pop up saying "No Results found".
Thanks