Search function to find customer

[ApolloCarrierServ]

I am just learning how to create VBA's and need some help please!

I have a worksheet that I am using to manage customer information. In rows "E" trough "T" are the fields for customer information such as customer name, address, phone,etc. I have over 1500 rows of information to keep track of. I am wanting to create a button that is a search function to quickly find a customer or customers based on a keyword search. For example if I type in the customers address will take me to that row on the worksheet. Or if I search a customers name it will show me all customers with that name.

Thank you!

 

[Fluff]

Why not just use an Advanced filter
https://www.ablebits.com/office-addins-blog/2016/09/07/excel-advanced-filter/

 

[ApolloCarrierServ]

I am using filters currently to sort the customers info. But lets say that I want to add a customer to my sheet, before I do I want to search first to make sure they don't already exist. So I want to type in the name and search for that customer. Or maybe all I have is the address, I want to search the address to find the customer.

 

[Fluff]

That's exactly what you can do with advanced filters.

 

[ApolloCarrierServ]

Does advanced filter need to be apart of the worksheet. Like it needs to have rows and columns dedicated to that function?

 

[Fluff]

Yes it does, but they can be on another sheet, or the sheet you want to filter.

 

[ApolloCarrierServ]

I am trying to keep to keep everything on 1 sheet. Is there a way to do a user form with a vba that displays the info in a list box, or applies a filter to the sheet?