Hi I'm trying to create a search form using a userform in excel. Find will not work for what I'm trying to do so I've created my own code. I can create a form that searchs the fields no problem, but I can only get it to work if the user enters the exact word as the one in the file.

I would like to be able for the user to just put in g if they want and it will pull up all the customer names that start with g. Can anyone help me with this.

Thanks,

Mickie