Modify Search code to look for specified text

[mrgillus]

Basically I have a code from an unknown source that will search a folder of excel workbooks for whatever text you place in the code in VB. I want to make this Excel Search File easier for someone who doesn't know much about VB. In other words, instead of them opening up VB and changing the search string in there, I want them to be able to type the search text into a cell and the click the Find it! button.. Attached is the file.

[mrgillus]

Does anyone have any ideas on this?

[wamp]

based on your example, change the strsearch to:

Please Login or Register  to view this content.