VBA code - Search box function - return value/text not location

[kruwo1]

Hi all,

I need help with a code for a search box function, that returns the information recorded in a cell for example, "Barcelona" or "London" etc), instead of the location of the cells.

I will need to narrow it down to search only the information in the following columns:

Sheet2
I2:J10932

I am totally new to VBA coding and have stumbled my way through a few things, but everything I have searched for so far has had at least one error when transposing to Excel.

I am running Excel 2007.

Thanks in advance!

[:) Sixthsense :)]

Whether the search should be whole cell match or part of the text?

[kruwo1]

Search will be of keywords so part of the text please!

[:) Sixthsense :)]

Code will run based on the input value mentioned in a1 cell. Change the Range("A1") to your desired cell in the below code.

Please Login or Register  to view this content.