Tag Archives: Search

How to Find an Exact Match Using VBA

The Search Feature in Microsoft Excel Before digging into how to look for exact matches in VBA, I’ll give you some context with the easiest way to accomplish this goal — the search function in Excel. Microsoft Excel provides us with an excellent feature that

No Thumbnail

Iterate and Search for Values in a Table, Access VBA

This article will explain how to perform a search operation on an Access table using VBA. Note: A faster approach for doing searches would be to use queries. For more information on this please see the link below: Recordset Query Search , Access VBA The article

No Thumbnail

Searching Data In Excel Sheets

One of the main tasks an Excel VBA programmer encounters is  searching excel sheets for a specific value. While there are many different methods for doing a search, in this article I will only cover the basic method of using a For Next loop. In

No Thumbnail

Simple Recordset Query Search , Access VBA

In this article I will explain how you can perform searches on Recordsets using queries. Previously in the article Iterate and Search for Values in a Table, Access VBA I’ve explained how you can perform searches on a recordset object using a simple iteration. The method in