This tutorial will explain how to find a value in an Excel column using the Find function in VBA. Excel will highlight all of the cells that correspond to your search. How to search data using the ...

Open an Excel workbook on your PC. You can now close the VBA window and go back to your Excel sheet. Pick a cell, type ...

To put an Excel function in VBA, you need to create a module. For that, open the Visual Basic panel and find the Microsoft Excel Objects . Next, right-click on it and select Insert > Module .

When a VBA solution falls short of your needs, there's probably a Windows API function that can handle the job. Susan Harkins lists 10 handy APIs and explains how you can put them to work.