How do I write the code for an autofilter criteria obtained from .

B

Bebe_dash

I am developing a program using Excel's Visual Basic for Applications and the
main aim of the program is to filter certain keywords from a list on the
excel sheet. However, I do not want to use the conventional Filter method
because of the size of data I have. Alternatively, I prepared a userform with
a textbox control that can enable me type any search criteria and a command
button that executes the program. But I do not know how to formulate my code
so that the text inputted in the textbox as my search criteria is filtered
when I click the command button.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top