Searching with ADO

An Excel file that teaches how to perform Searching with ADO operation.

Excel Powered Searching with Ado

The criteria is taken from the form field. The WHERE condition is created dynamically. The query result record set is displayed on the ListBox. The user can quickly access the record he is looking for.

Hope it is useful.