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

**kruwo1** · 05-15-2014, 01:02 AM

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 :)** · 05-15-2014, 01:09 AM

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

**kruwo1** · 05-15-2014, 01:41 AM

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

**:) Sixthsense :)** · 05-15-2014, 01:55 AM

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.

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Search for Text and Return Cell Location

Code that works in one location but not another location. (AdvancedFilter excel function)

Excel 2007 : How do I search an address text string within a column and return the zip code in the

Excel 2007 : Search for text and go to location in worksheet

VBA Code to Return Text Embeded in the VLOOKUP Function

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions