Search/Find function in excel worksheet
Hi,
I found the following thread very useful:
http://www.excelforum.com/excel-gene...worksheet.html
Is it possible:
- To revise the code to search and find the string of characters entered in cell A1 instead of searching for an exact match in a cell?
- To revise the code to mimic "Find Next" in the Cntl-F function?
To install the code:
- Right-click on the sheet tab
- Select View Code from the pop-up context menu
- Paste the code from below in the worksheet's code module
- Change the Criteria cell and search range to suit
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Hi,
I copied the code but it does not work.
With the prior code, I entered a value in cell A1 and pressed enter.
With the new code, where/how do I specify the search range?
The current search range is column B.
With Range("B:B")
What search range do you want?
Hi,
It works like a champ!
I am not very fluent in reading (and understanding) vb code.
With your explanation from your reply, I went in and changed the search range to column F which is what I wanted to search.
Everything works great! Thanks.... you will save me a lot of time looking up asset tag numbers.
You're welcome. I hoped the green comments would help explain the relevant parts of the code.
Hi,
I tried using the same vb code in another tab of the same spreadsheet.
It did not work. I even changed the name of the private sub thinking excel might get confused with the same name for a private sub (even though the code on 2 different tabs).
The code still did not work.
I am searching through phone numbers. The column is formatted to (999) 999-9999. The actual value in the cell is 9999999999.
Any help would be greatly appreciated.
Chanage this.
The macro name has to be Worksheet_ChangePlease Login or Register to view this content.
Hi,
I did what you said and it still does not work. When I put in the value 682215 and press enter, the cursor just goes to the next line down.
Here is a snippet of my data (column A is the carrier, Column B contains the phone number):
682215 <----Search Value
Wireless
Carrier Current Number
AT&T (682) 201-1481
AT&T (682) 201-6041
AT&T (682) 201-7207
AT&T (682) 201-7419
AT&T (682) 201-9901
AT&T (682) 215-1388
AT&T (682) 215-1643
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Ok. There is a sample spreadsheet uploaded.
Thank you for your help.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks