VBA User Form Combo Boxes Dependent on a category

[Caveman1964]

Not sure if I use a list box or combo box but I want a macro to call a userform which has a list of the categories in this table.
It places the major category in a cell, then another message comes up asking for the item which is dependent on the category.
Say for example, if the user selects fruits, it puts fruits in cell B3 and the next message he chooses Figs, it puts figs in cell B4.
and only fruits show up as choices. I hope I explained well and would appreciate any help.

	A	B	C
1	Fruits	Veges	Crafts
2	Apples	Squash	Birdhouse
3	Figs	Tomatoes	Doghouse
4	Pears	Onions	Chicken Coup
5	Apricots	Okra
6	Peaches

<tbody>
</tbody>

 

[Michael M]

You can use data validation for this have a look here for a quick tutorial and steps on how to do it......

https://www.contextures.com/xlDataVal02.html