Search Form
 

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

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!


--
kylev96
------------------------------------------------------------------------
kylev96's Profile: http://www.excelforum.com/member.php...o&userid=23983
View this thread: http://www.excelforum.com/showthread...hreadid=376001