create a find box in excel vba

[denvernuggets15]

hi, i can't seem to figure out how to make a search/find box that will select the text the user inputs.

[GaidenFocus]

Here is a user form search system. If you need help creating it yourself let me know!

[GaidenFocus]

You can also hit CTRL + F though

[denvernuggets15]

Thank you GaidenFocus! The search box is great! Just one thing: The userform closes everytime I type in something and hit the OK button. How could you make it stay open unless Cancel is hit? That way you wouldn't have to open it everytime you want to find something.
Thanks again!

[GaidenFocus]

Here you go, let me know if it doesn't work!

[denvernuggets15]

Thanks again. I did run into one other problem. I erased your values in column A and wrote some other values in other cells and ran the search, it won't find any other values unless they are in cell A1. For example, if the word "tax" is in F5, and I search for "tax", it displays Not Found. If "tax" is written in A1, it does find it.

[GaidenFocus]

OK here is a simpler version.

[denvernuggets15]

It works. Thanks for your help.

[GaidenFocus]

No problem! Glad i could help.

[rimvis]

OK here is a simpler version.

could u give me the same file just in xls format, thanx a lot.