Form Control to search for keywords and open File

[namy77]

Good morning folks,

I have a 3 column layout to organize my files, their keyword and their local links.

xccFH0b.png

I wonder if, by using UserForm, I can build a small search engine to query and open my files by keywords? Something like this:

Auto complete by filling the rest of the keyword text and locate file(s) that share those keywords.
xbqOoh4.png

It would also be nice if it can recognize any part of the keyword, not just the beginning. For example:

3GJWnbc.png

and obviously, clicking on one of the recommendations will launch that spreadsheet using the link in Column F via something like

Please Login or Register  to view this content.

Thanks a lot, this will help me stay very organized and query information rather quickly.

[Kenneth Hobson]

I would use this sort of method for the Listbox. Here is the link since file attach did not work:
https://www.dropbox.com/s/ztnr49hf4r...tbox.xlsm?dl=0

Right click the sheet's tab and View Code to see how I called it from the sheet. You can use it in other ways as well.

Once you have the value, you can do a find for the same range that you used to fill it. After that range is found, an Offset is used to get the path.

Attach a simple file if you get stuck.