Search using a Word/Phrase

Hello there,

Where would you like the results displayed?

Options:
1.Highlight found cells
2.Userform to search and populate listbox which found cells. Clickable list box that when clicked takes you to cell
3. Populate all found cells in another worksheet.

Thanks!

Just below the "where i ll enter the word/phrase" .... thanks for yyour so quick response

Hi Mike,

Thanks for your reply, where do I enter the Text that i have to search for ? :| Thanks again

Hi Mike, Sorry to post again, but can this be displayed in sheet instead of the MsgBox, and can the input be from sheet itself like suppose B10 cell or B1 any one... Really would be helpfull

---------- Post added at 08:24 PM ---------- Previous post was at 08:14 PM ----------

What does .Cells(.cells.count) do?

Hi,

Please find the attached file, this the data is from the macro search for things, and the Search tab is where the Data will be entered and displayed

Hello there,

Please see the below thread, it provides an example of a macro and dynamic ranges. The workbook is very similar to yours.

http://www.excelforum.com/excel-gene...html?p=2884819
Thanks!

Hi Rvasquez, Thanks for the reply, but that will not solve my problem

---------- Post added at 09:13 PM ---------- Previous post was at 09:06 PM ----------

Hi mike, any updates really need it soon sorry I am bugging you so much

Thanks a lot for the sheet MIke you are Great outstanding.

Hi Mike i was writing this code in the VB but i just dont know when to start a macro and when to write he code because after i write the code and execute it it doesnt show any result so please tell me when to start a macro either before writing the code or after

Hi, thanks for the file, but it keeps appearing as a read only whenever I try to save and says I cannot run a macro as a read only. Any insight?

Hey thanks for this post! This has helped me a lot!!!!

This is great but how do I add an additional column for results? This file only give two results, Material and Material Description? I need at least 4 more descriptions. Are you able to help?

I have a question, here at work we utilize a system that has procedures. I have tried grabbing the most relevant procedures we use and making a data base of them. The question I have is when I do a query search and the information pulls over if it is a hyperlink how is it possible to have the hyperlink to pull over with the data and still be able to use it.

@jand13j
Please read post #16 by arlu1201.