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.
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.