Hello to all in forum,
I have a database in sheet1 with 5 columns (A-E). I would like to have a VBA userform that allows me to select books by genre shows me within the userform all rows for that genre and columns A,B, D and E.
Example: Having a list of genres in the userform, select "Action", and in the userform should display 3 rows
I really new with VBA userforms. May somebody help me sh0wing me how to pull the data based on genre and show the
result table inside the userform.
<tbody>
</tbody>
Thanks for any help.
Regards
I have a database in sheet1 with 5 columns (A-E). I would like to have a VBA userform that allows me to select books by genre shows me within the userform all rows for that genre and columns A,B, D and E.
Example: Having a list of genres in the userform, select "Action", and in the userform should display 3 rows
I really new with VBA userforms. May somebody help me sh0wing me how to pull the data based on genre and show the
result table inside the userform.
Genre | Title | Year | Author | Read |
Drama | Drama_1 | 1980 | John T. | 130 |
Romance | Romance_1 | 1983 | Mary D. | 215 |
Action | Action_1 | 1986 | Jane M. | 300 |
Romance | Romance_2 | 1989 | Mary D. | 120 |
Children | Children_1 | 1992 | Paul S. | 381 |
Action | Action_2 | 1995 | John T. | 87 |
Fantasy | Fantasy_1 | 1998 | Kevin W. | 95 |
Children | Children_2 | 2001 | Mary D. | 103 |
Action | Action_3 | 2004 | Jane M. | 204 |
Horror | Horror_1 | 2007 | Kevin W. | 167 |
<tbody>
</tbody>
Thanks for any help.
Regards