How to Create a Search Macro?

**shendel** · 05-22-2013, 02:17 PM

Hey guys,

So I'm sort of new to all this macro creating business on Excel. Anyways, I have a sheet with Number, First Name, Last Name, Nickname, and Birthday. I need to create some sort of way to search for a specific name so that the sheet will jump to the row in question. If not that, then a pop up window that will say what row the input is in. Any ideas for how to go about this?

Let me know!

Thanks,

Sara

P.S. I'm using Excel 2011 for Mac

**xladept** · 05-22-2013, 04:17 PM

Hi Sara,

Try this:

Please Login or Register  to view this content.

Or This:

Please Login or Register  to view this content.

Directions for running the routine(s) just supplied

Copy the code to the clipboard

Press ALT + F11 to open the Visual Basic Editor.

Open a macro-enabled Workbook or save your Workbook As Macro-Enabled

Select “Module” from the Insert menu

Type "Option Explicit" then paste the code under it

With the cursor between Sub and End Sub press F5 (F8 to Single Step)

OR

Press ALT + Q to close the code window.

Press ALT + F8 then double click on the macro name

**Ed_Collins** · 05-22-2013, 04:23 PM

Hi Sara,

If this doesn't work, it's because I no absolutely nothing about the Mac. But the code works on my PC (Excel 2007) and even if it doesn't work, it should give you a few ideas.

For now, assume your names to be searched are all in the A column.

In Cell A1, enter the name you wish to search for. Then run this code:

Please Login or Register  to view this content.

I specifically tried to make it as short and as simple as possible.

What it does: It loops through all of the rows, looking at the data (the names) in the A column. With each row it checks to see if the name in that row is the same name as what you entered in Cell a1. If so, it breaks out of the loop and reports the row it found the name in. Otherwise it continues until it comes to the first empty cell in column A.

Again, it should help to get you started and you can modify it to fit your needs.