Form to search and return row from sheet1

[Drunknmonkie]

I know you can do a search by clicking on the column header, but there are a lot of people i work with who have even less computer knowledge than me so a search box/form would be the ideal way.

I have tried making one up by doing the record macro feature but i have no idea as to what needs changing or making to get the search box to appear on the spread sheet page.

Also i see that it can be made in to an exe. file..... now that would be niffty!

Hi all i have a worksheet that has a list of special tools.

What i need to do is add a search function to it (this needs to be easy for all our staff to understand - i.e. a form where it has a search box and then a text field underneath that returns the part searched (the complete row))

Also i would like the box to be able to have an add function so its possible for me to add new tools to the list. (this is not that important the search function is more important)


Many thanks in advance

P.s im crap at excel so any explanation of the code is much appreciated

An example of a form that would be ideal Form.JPG

SST Part List New.xlsx

[Drunknmonkie]

bumb to hope someone can help :P