Leith Ross
Forum Moderator

How can I change the status of my thread to "Solved".
Andy Pope posted a solution that helped me resolve my problems.

Thanks

Mr. Ross - please do delete any of my attachments (you may want to look at "Lost Visual Basic Project" as well as "listbox control source causing error")that you feel are probably damaged files. My sincerest apologies for any trouble I've caused. I appreciate greatly the help provided on this forum and look forward to improving my VBA skills with your help and that of your colleagues.

Dear Mr. Ross,
please take a look at my edited post:

http://www.excelforum.com/excel-prog...ml#post1986626

Thanks, Mike

Always go w/ professional option . if you could send me info or a good reference link on the pop up method i'd really appreciate it. Thx, B

where can I read more about your 'right click menu option to run the macro'? it sounds like a handy item to use. is there a link suggesting possible applications? Instead of buttons on a form i put mt buttons on the toolbar to clean it up. but i still need to add them to multiple users machines. when using the above option could a list open w/ several choices? (print this, save that, email the other?) thank you in advance for your help. Brian H

Hi Leith - the code you published just now ... address = $C:$F ... won't this only be true if cells between cols C & F are selected? i.e. not the whole row?

Hello,
Thanks a lot. The revised form is although working but I am having few problems in its total achieving.

• The three columns in worksheets are “Text” (Even numbers have been entered as “Text”
• The “Search Result” shows like: Sheetbooks!$C$1. I wish that it should be like; when content(value) of any Column A , B and C is entered in “Search for” text box, the result may be the value of A, B and C . An example of Sheet Books is:

A B C
1 0123 4567 Science
2 1234 4678 Science fiction
3 4321 9988 Science notes

If I enter in “Search for” box 0123 or 4567 or Science, the result may be:

0123 4567 Science

I feel that following part needs to be changed accordingly.
=======
Do
SearchResult = Wks.Name & "!" & FoundCell.Address
ListBox1.AddItem SearchResult
Set FoundCell = Rng.FindNext(FoundCell)
Loop While FoundCell.Address <> FirstAddx And Not FoundCell Is Nothing
==========

• If there is any possibility that the content of “Search result box” when clicked by mouse be highlighted and pasted in different sheet named “result”. The first result in first row, second in second and so on.
• Search function may please be restriction free i.e. without ‘match case’, or match entire cell contents. The quest for word science may give result of all three above example entries and then only the required one by clicking be pasted in “result” sheet. Similarly the quest for word fiction may fetch “science fiction” and “fiction related all words”.

I thank you once again.

Flower R.

Hello! whenever you have time, please help me in post "search engine for multiple sheet" Thanks.
Flower R

Hello! I think my post about exportin data have been resolved, partly by help of the forum and partly by me getting a good idea of what i could do, however it has been open for more than 2 days and thus I cannot change it to "Solved". Thus could you perhaps do it for me?
The thread is http://www.excelforum.com/excel-gene...rom-excel.html

Thanks in advance

Hi Leith,

Thank you for solving "Looping through Array". I could not mark is "Solved" since it is closed. So, can you mark it as solved?
Thanks again.

Samir