Using Find and FindNext in Excel VBA to Populate a ListBox with Addresses of Search Term

This video demonstrates how use the Find and FindNext functions in Excel VBA. In this example, a ListBox on a UserForm will be populated with the cell addresses matching the search term.

[erkanakdogan]

Loved this but how about if we would like to get data of next column like vlookup?

[kimeeshareedwalker]

Excel configurations are complicated. I would rather stick with SPSS. Seems like you have to do to many inputs manual in Excel.