Hi all,

I am looking for a code that would possibly work with a userform to search files within a Folder (Specified by a Textbox) for a specific word (again specified by a textbox) with the results being the file name and location that that word is located in.

So for example. A UserForm with TextBox1 where you would input a word "ELLIS" and then in TextBox2 you could either input the location of a particular folder Documents "C:\Users\Christopher.Ellis" or use a Command Button where you could choose the folder on your PC.

Then a search button that would search for the Text in Textbox1 (either a full or partial match) in the files located in the folder specified by TextBox2.

Then TextBox3, or a ComboBox showing a list of files that contain their word - with their location - (ELLIS123.XLS C:\Users\Christopher.Ellis)

Does anyone know of anything that would do this? I.e. how I would search the specific text in files in the specified location?

Many thanks,

Chris