I'm looking to create a VBA to filter the entries in a column (either strings or numbers) based on the input in a text box. Currently I was looking at using the ActiveX TextBox to hold the input. Ideally the function would search for partial matches as well as exact.
An example would be that the user inputs "er" in the text box and then any cell in the specified column with "er" in it would be shown and all other rows would be hidden. So 'Dover' and 'Ergonomic' (exact matches) would both be displayed as would 'Rob' and 'Age' (partial matches).
Even if you could just demonstrate how I could create a filter based on the input from the text box that would get me a lot closer.
Thank you in advance for your help.
An example would be that the user inputs "er" in the text box and then any cell in the specified column with "er" in it would be shown and all other rows would be hidden. So 'Dover' and 'Ergonomic' (exact matches) would both be displayed as would 'Rob' and 'Age' (partial matches).
Even if you could just demonstrate how I could create a filter based on the input from the text box that would get me a lot closer.
Thank you in advance for your help.