Userform Filter Search

[atqed]

Hi,

I would like to know if it is possible in Excel to create a userform search function with vba, that displays the row of the next related data set from a database in a new sheet?

For Example:

Column A Column B

Max3D 3$
Max4D 4$
Max5D 6$
Tyrone 8$

Search Entry: Max

Filter Results:

Column A Column B

Max3D 3$
Max4D 4$
Max5D 6$

[Yongle]

So that I can better understand what you are trying to achieve:

1 Will the search condition always be to search for items "beginning with..."
- beginning with Max, beginning with Tyron etc
2 Please attach an Excel workbook with a minimum of 20 rows of valid data and all the columns you want to display

3 Do not attach any pictures or jpegs etc

thank you