hi, everyone!

I'm new to excel vba and I just need help.

2 combobox are in a userform1

possible rowsource:
sheet1 for food lets say all is in row A
Sheet2 for drinks

Combobox1 as 2 choices e.g. food, drinks
IF food is selected then rowsource from sheet1 will auto populate
IF drinks is selected then rowsource from sheet2 will auto populate

I'm not really sure on how to do this.
I don't even have a sample code or something.
I really hope someone can help me out. I would really appreciate it.