combobox populated based off of other value

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

You something like this in your Userform Module.
Change the Range Addresss to suit you Lists

Private Sub UserForm_Initialize()
With ComboBox1
.List = Array("Auto", "Transport", "Entertainment", "Food and Dining")
.ListIndex = 0
 End With
End Sub

Private Sub ComboBox1_Change()
Select Case ComboBox1.Value
    Case Is = "Auto": ComboBox2.List = Range("A1:A10").Value
    Case Is = "Transport": ComboBox2.List = Range("B1:B10").Value
    Case Is = "Entertainment": ComboBox2.List = Range("C1:C10").Value
    Case Is = "Food and Dining": ComboBox2.List = Range("D1:D10").Value
End Select
ComboBox2.ListIndex = 0
End Sub

thanks ill have to look into the links and MickG that code was just what i needed

thanks everyone