--------------------------------------------------------------------------------

I'm currently working on a project allowing customers to search past questions asked by other customers. Sheet1 consists of a macro that brings up a userform, Sheet2 consists of about 500 questions and answers set up in simple Q&A format.

When the userform comes up, I have a:

Textbox (to enter search query)
2 command buttons (Search and cancel)
a Checkbox (for 'contains' rather than 'exact')
and a listbox (to retrieve results, query matching any of the FAQ's)

Now I've stumbled my way through most of the code, not much of a programmer but I've taken a few courses and know my way around excel pretty well...but haven't really had much success. All I want to do is for the userform in Sheet1 to search the questions/answers on Sheet2, retrieve the results in the listbox, and double-clicking on the result in the listbox letting you view the whole question/answer.

Can someone out there help me!? Thanks!