Hi,

I know this forum isnt really the place for Excel Macro questions but i'm not sure where else to go :L

I have created an excel sheet which holds all the movie's I own and a macro which allows me to add a new movie, find a movie, delete a movie, etc.

The problem is when I search for a movie using my 'FIND' button and entering my search, the worksheet scrolls through the movie's and finds the movie's which meet my criteria alphabetically (first word). Instead I would like for the macro to open a new box or even sheet which contains all the movie's which contain the word/phrase I have entered in my search field.

So I was wondering if anyone has any ideas about how I should change my code or how I should go about doing it. More information can be provided as needed. (:

thanks,