Create a search engine in excel form

Hi VBA gurus,

I am very new to VBA and would like to ask experts out there how can I create a text box in the excel forms to allow users to search some information based on the text entered. It is similar to a search engine. The database that store the information is using MS SQL Server 2008 and I'm using excel 2007.

Can anyone here share some sample code so that I can have something to kick-start with?

Thanks.

This would search on a sheet, if that helps any:

Please Login or Register  to view this content.

Unfortunately an SQL query is a bit out of my league. However, see if this helps:

http://stackoverflow.com/questions/7...-a-spreadsheet

Before we get into the VBA, have you tried parameter queries? http://msdn.microsoft.com/en-us/offi...ab_topic3.aspx