I need to alter the function "Search" of the attached userform.
In the sample file I am searching by name. What the code does now is to display all the rows with the searched criteria in the listbox.
I need to change that and to display only 5 randomly selected rows with the searched criteria. I have tried to play with arrays but could not do it.
Hope that someone can help.
Bookmarks