Get EVERY cell addresses for search results not just the 1st!

All,

I hope you guys can help me with the below issue.

In the attached workbook, there is data in column A.

The workbook's only macro is triggered by a button that generates a simple search form.

The macro highlights all the occurrences of the search word perfectly; but only returns the first address, NOT every address (Try inputting "3")

Obviously, I need ALL the cell addresses of every cell that has the word or search string in it.

So, at the moment, I only get the first incident for the search, and can't suss out how to get the other responses!!

I think the issue lies within this part of the code:

Please Login or Register  to view this content.

Please could somebody have a look and tell me what I'm doing wrong or suggest a workaround?

Thanks for looking.

Skyping

You would need add it to a string each time it loops.

Please Login or Register  to view this content.

I actually just noticed your search function isn't explicit and will find any cells containing the number, so in your example, if I searched for 5, it returns the cell with "5" and also the cell with "45"

you can fix this by replacing;

Please Login or Register  to view this content.

With

Please Login or Register  to view this content.

Thank you both so much....absolutely brilliant!!

SOLVED

I have a StaffListing spreadsheet 'tab' (main reference to each individual) with FName, LName, Rank, and IDNumber. Staff can attrition in and out of listing. Max size is 125 members.

Like in a database, I would like to have the StaffListing repeated automatically into each new spreadsheet tab within the file, so that I only have to update the StaffListing once with changes and those changes auto-add to each subsequent spreadsheet tab. Additionally to the StaffListing, there are other tabs with pertinent info, such as attendance, promotions with dates and rank, reimbursement of expenses, training, duties and more.

Question: how do I 'autolink' the StaffListing to other spreadsheet tabs, and then design an input page under each category ... like in a database. Staff listing will not exceed 125 members.

Thank you!