im creating a userform and i have two catagories that i have pull down lists for. the first one are catagories like Auto & Transport, Entertainment, Food and Dining, ect. I can populate that list but the next list will be based off of what catagory i choose in the first list. Say if I choose Food and Dining. then the next drop down box i want the options Fast Food, Groceries, Restaurants, Coffe Shops, Alcohol & Beer, and other to be populated. and if another option is choosen then i want different lists to populate in that dropdown box.

If someone can give me the general way of doing or any help or direction with this i can play around with it

thank you
jed38